------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20250822-brfss2019-dataprep.log
  log type:  text
 opened on:  25 Aug 2025, 05:02:30
r; t=0.02 5:02:30

. version 15.1
r; t=0.00 5:02:31

. clear   all
r; t=0.03 5:02:31

. macro   drop _all
r; t=0.00 5:02:31

. set     linesize 80
r; t=0.00 5:02:31

. set     scheme plottig
r; t=0.02 5:02:31

. set             more off
r; t=0.00 5:02:31

. set             varabbrev off
r; t=0.00 5:02:31

. set     rmsg on
r; t=0.00 5:02:31

. 
. // #0. Document this do-file
.         local today : di %tdCY/N/D daily("$S_DATE", "DMY")
r; t=0.00 5:02:31

.         tokenize `today',parse("/")
r; t=0.00 5:02:31

.         local year `1'
r; t=0.00 5:02:31

.         local month `3'
r; t=0.00 5:02:31

.         local day `5'
r; t=0.00 5:02:31

. 
.         local who "Ben Cheung"
r; t=0.00 5:02:31

.         local pgm "20250822-brfss2019-dataprep"
r; t=0.00 5:02:31

.         local date "`year'-`month'-`day'"
r; t=0.00 5:02:31

.         local tag "`pgm'.do by `who' on `date'"
r; t=0.00 5:02:31

.         display "The tag is: `tag'"
The tag is: 20250822-brfss2019-dataprep.do by Ben Cheung on 2025-08-25
r; t=0.00 5:02:31

. 
. 
.         local today : di %tdCYND daily("$S_DATE", "DMY")
r; t=0.00 5:02:31

. 
. 
.         *Check for installed packages
.         capture which scheme-plottig.scheme
r; t=0.00 5:02:31

.         if _rc!=0 ssc install blidschemes
r; t=0.00 5:02:31

. 
.         capture which confirmdir
r; t=0.02 5:02:31

.         if _rc!=0 ssc install confirmdir
r; t=0.00 5:02:31

. 
.         capture which estout
r; t=0.01 5:02:31

.         if _rc!=0 ssc install estout
r; t=0.00 5:02:31

. 
.         capture which sum2docx
r; t=0.00 5:02:31

.         if _rc!=0 ssc install sum2docx
r; t=0.00 5:02:31

. 
.         capture which tab2xl
r; t=0.02 5:02:31

.         if _rc!=0 net install http://www.stata.com/users/kcrow/tab2xl, replace
r; t=0.00 5:02:31

. 
.         set scheme plottig
r; t=0.00 5:02:31

. 
. 
. local folder "Original data"
r; t=0.00 5:02:31

. confirmdir "`folder'"
r; t=0.00 5:02:31

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 5:02:31
. }
r; t=0.00 5:02:31

. 
. 
. 
. local folder "Data Ready for Analysis"
r; t=0.00 5:02:31

. confirmdir "`folder'"
r; t=0.00 5:02:31

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 5:02:31
. }
r; t=0.00 5:02:31

. 
. 
. 
. 
. *Define custom program to show command in loop
. program define pe
  1.         version 15.1
  2.         if `"`0'"' != "" {
  3.                 display("")
  4.                 display as input `". `0'"'
  5.                 `0'
  6.                 display("")
  7.         }
  8. end
r; t=0.00 5:02:31

. 
. 
. 
. 
. 
. // #1. Data management
. import sasxport "Original Data/LLCP2019.XPT",clear
r; t=50.44 5:03:21

. 
. 
. 
. 
. // #2. Data management
. *Survey setup in Stata: https://www.cdc.gov/copd/pdfs/BRFSS_COPD_Syntax.pdf
. 
. *calculated variables for race vary across years:
. *_racegr (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic, 
> 4=Other, 9=missing (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *_racegr2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_racegr3 (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HTML)
. 
. 
. *race (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic-whit
> e, 4=Hispanic-black, 5=Other hispanic, 6=Non-hispanic asian/Pacific Islander, 
> 7=Non-hispanic Native American, 8=Non-hispanic other, 9=missing (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *race2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  asian, 4=Non-hispanic Native Hawaiian/Pacific Islander, 5=Non-hispanic Native
>  American, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2001/pdf/riskfactor_01.pdf)
. *_race (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  Native American, 4=Non-hispanic asian, 5=Non-hispanic Native Hawaiian/Pacific
>  Islander, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2013/pdf/2013_calculated_variables
> _version15.pdf)
. 
. 
. *Starting from 2001, Hispanic was no longer further partitioned into different
>  racial groups (i.e., Hispanic-black, Hispanic-white...).
. *Since I need to construct Hispanic non-black and Hispanic Black as two racial
> /ethnic groups in the data, I need to obtain the original racial and ethnic gr
> oups variables to compute these two groups myself.
. *_prace (2001-2012): 1=White, 2=Black/African American, 3=Asian, 4=Native Hawa
> iian/Pacific Islander, 5=American Indian/Alaskan Native, 6=Other, 7=No preferr
> ed race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refus
> ed (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_prace1 (2013-2019): 1=White, 2=Black/African American, 3=American Indian/Ala
> skan Native, 4=Asian, 5=Native Hawaiian/Pacific Islander, 6=Other, 7=No prefer
> red race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *hispanc2 (2001-2012): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_hispanc (2013-2019): 1=Hispanic/Latino/Spanish origin, 2=Not of Hispanic/Lat
> ino/Spanish origin, 9=Don't know/refused (https://www.cdc.gov/brfss/annual_dat
> a/2013/pdf/CODEBOOK13_LLCP.pdf)
. 
. 
. 
. *survey weight:
. *_finalwt (1993-2010): 9999999999=unknown (https://www.cdc.gov/brfss/annual_da
> ta/1993/pdf/layout93.pdf)
. *_llcpwt (2011-2019): (https://www.cdc.gov/brfss/annual_data/2011/pdf/BRFSS201
> 1_Analysis.pdf)
. 
. 
. *strata:
. *_ststr (1993-2019)
. 
. *PSU:
. *_psu (1993-2019)
. 
. *Questionnaire version:
. *_qstver (1997-2001): 1=Version 1, 2=Version 2, BLANK=Not applicable (https://
> www.cdc.gov/brfss/annual_data/1997/files/CODEBK97.TXT)
. *_qstver (2002): No documentation and the categories are weird (https://www.cd
> c.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *qstver (2003): 1=Version 1, 2=Version 2, BLANK=Missing (https://www.cdc.gov/b
> rfss/annual_data/2003/pdf/Codebook_03.pdf)
. *qstver (2004-2007): 0=Only version, 1=Version 1, 2=Version 2, BLANK=Missing (
> https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *qstver (2009): 0=Only version, 1=Version 1, 2=Version 2, 3=Version 3, BLANK=M
> issing (https://www.cdc.gov/brfss/annual_data/2008/pdf/codebook08.pdf)
. *qstver (2010): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3 (htt
> ps://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *qstver (2011): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3, 20=
> Only Version Cell Phone (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBO
> OK11_LLCP.pdf)
. *qstver (2012-2019): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3
> , 20=Only Version Cell Phone, 21=Version 1 Cell Phone, 22=Version 2 Cell Phone
> , 23=Version 3 Cell Phone (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODE
> BOOK12_LLCP.pdf)
. 
. 
. 
. *age:
. *age (1993-2012): 07=Don't know/not sure, 09=Refused
. *_age80 (2013-2019): imputed age from 18 to 80
. 
. 
. *employment status:
. *employ (1993-2012):1=Employed, 2=Self-employed, 3=Out of work for more than 1
>  year, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 
> 8=Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/la
> yout93.pdf)
. *employ1 (2013-2019):1=Employed, 2=Self-employed, 3=Out of work for 1 year or 
> more, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 8
> =Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/2013/pdf/COD
> EBOOK13_LLCP.pdf)
. 
. *sex:
. *sex (1993-2017): 1=Male, 2=Female, 9=Refused (https://www.cdc.gov/brfss/annua
> l_data/1993/pdf/layout93.pdf)
. *sex1 (2018): 1=Male, 2=Female, 7=Don't know/not sure, 9=Refused (https://www.
> cdc.gov/brfss/annual_data/2018/pdf/codebook18_llcp-v2-508.pdf)
. *sexvar (2019): 1=Male, 2=Female (https://www.cdc.gov/brfss/annual_data/2019/p
> df/codebook19_llcp-v2-508.HTML)
. 
. 
. *SRH:
. *genhlth: 1=Excellent, 2=Very good, 3=Good, 4=Fair, 5=Poor, 7=Don't know/not s
> ure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *In 1996, Tennessee (FIPS: 47) didn't ask the SRH question.
. 
. *Number of days in last month with not good physical health:
. *physhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month with not good mental health:
. *menthlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month keeping R from usual activities due to poor phys
> ical/mental health:
. *poorhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. 
. *Asthma (ever told by doctor you have asthma):
. *asthma (1999-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *asthma2 (2001-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped or missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pd
> f)
. *asthma3 (2011-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. *Cholesterol (ever told by doctor you have high blood cholesterol):
. *toldhi (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://ww
> w.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *toldhi2 (2001-2005, 2007, 2009, 2011, 2013, 2015, 2017, 2019): 1=Yes, 2=No, 7
> =Don't know/Not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2001/pd
> f/codebook_01.pdf)
. 
. *Heart attack (ever told by doctor you have heart attack) (asked by all states
>  since 2005):
. *cvdinfar (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdinfr2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdinfr3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdinfr4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Coronary heart disease (ever told by doctor you have coronary heart disease) 
> (asked by all states since 2005):
. *cvdcorhd (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdcrhd2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdcrhd3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdcrhd4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Stroke (ever told by doctor you have stroke) (asked by all states since 2005)
> :
. *cvdstrok (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdstrk2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdstrk3 (2005-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. 
. 
. *Diabetes (ever told by doctor you have diabetes):
. *diabetes (1993): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *diabetes (1994-2003): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/N
> ot sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *diabete2 (2004-2010): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *diabete3 (2011-2018): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *diabete4 (2019): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline diabet
> es but during pregnancy, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or mi
> ssing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.H
> TML)
. 
. 
. *High blood pressure (ever told by doctor you have high blood pressure):
. *bphigh (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *bphigh2 (2001): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skipped 
> (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *bphigh3 (2002-2004): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/No
> t sure, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook
> _04.pdf)
. *bphigh4 (2005, 2007, 2009, 2011, 2013, 2015, 2017, 2019): 1=Yes, 2=Yes but du
> ring pregnancy, 3=No, 4=borderline high, 7=Don't know/Not sure, 9=Refused, BLA
> NK=skipped (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-
> 508.pdf)
. 
. 
. *last routine checkup:
. *checkup (1993-2002, 2005-2006): 1=1 to 12 months ago, 2=1 to 2 years ago, 3=2
>  to 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 8=Never, 9=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *checkup1 (2007-2019): 1=less than 12 months ago, 2=1 to less than 2 years ago
> , 3=2 to less than 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 
> 8=Never, 9=Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_
> LLCP.pdf)
. 
. 
. *******************Alcohol drinking questions start*******************
. *Any alcohol drinking in past 30 days:
. *drinkany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *(no such question in 2001-2004, since it was combined with alcdays and alcday
> 3. There were calculated variables based on alcdays and alcday3)
. *drnkany4 (2005-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *no such question in 2010-2019, since it was combined with alcdays and alcday3
> . There were calculated variables based on alcday5)
. 
. 
. *Days of alcohol drinking in the last 30 days (asked by all states since 2001)
> :
. *alcohol (1993-2000): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-231= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_d
> ata/2000/pdf/codebook_00.pdf)
. *alcdays (2001): 101-107=Number of days per week (1 indicates weekly number), 
> 201-230= Number of days per month (2 indicates monthly number), 777=Don't know
> /Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss
> /annual_data/2001/pdf/codebook_01.pdf)
. *alcday3 (2002-2004): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2002/pdf/codebook_02.pdf)
. *alcday4 (2005-2010): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2010/pdf/codebook_10.pdf)
. *alcday5 (2011-2019): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *******************Alcohol drinking questions end*******************
. 
. 
. 
. 
. *******************Smoking questions start*******************
. *Ever smoked at least 100 cigarettes in life:
. *smoke100 (1993-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. 
. 
. *Currently a smoker or not:
. *smokenow (1993-1995): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout95.pdf)
. *smokeday (1996-2004): 1=Everyday, 2=Some days, 3=Not at all, 9=Refused, BLANK
> =skipped (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. *smokday2 (2005-2019): 1=Everyday, 2=Some days, 3=Not at all, 7=Don't know/Not
>  sure, 9=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. 
. *Number of cigarettes now smoke per day:
. *smokenum (1993-2000): 1-87= Number of cigarettes (1 pack=20 cigarettes), 88=D
> on't smoke, 99=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout9
> 3.pdf)
. *(This question was not asked since 2001)
. *******************Smoking questions end*******************
. 
. 
. 
. *******************Fruit and vegetables questions start*******************
. *How often drink fruit juice?
. *fruitjui (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. *fruitju1 (2011-2013, 2015): 101-199=per day, 201-299=per week, 300=Less than 
> one time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruitju2 (2017, 2019): 101-199=per day, 201-299=per week, 300=Less than one t
> ime per month, 301-399=per month/year, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-50
> 8.pdf)
. 
. *How often eat fruit?
. *fruit (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per day
> , 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’t 
> know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/Cod
> ebook_05.pdf)
. *fruit1 (2011, 2013, 2015): 101-199=per day, 201-299=per week, 300=Less than o
> ne time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=
> Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruit2 (2017, 2019): 101-199=per day, 201-299=per week, 300=Less than one tim
> e per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=Refuse
> d (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. 
. *How often eat green salad?
. *greensal (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat potatoes (not fried)?
. *potatoes (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat carrots?
. *carrots (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per d
> ay, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’
> t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/C
> odebook_05.pdf)
. 
. *How often eat vegetables?
. *vegetables (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=pe
> r day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=D
> on’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. *Number of daily servings of fruits and vegetables
. *_frtserv (1994): 0-999.98=numbers of times per day, 999.99=Don’t know/refused
> /missing (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.pdf)
. *_frtserv (1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 0-99998=numbers of
>  times per day, 99999=Don’t know/refused/missing (last two digits correspond t
> o two decimal places) (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK
> 96.TXT)
. 
. *Number of fruit consumed per day (the two following variables' last one digit
>  should correspond to one decimal place, but the codebook mis-stated that the 
> last two digits correspond to two decimal places)
. *_frutsum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_frutsu1 (2017, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. 
. *Number of vegetables consumed per day (the two following variables' last one 
> digit should correspond to one decimal place, but the codebook mis-stated that
>  the last two digits correspond to two decimal places)
. *_vegesum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_vegesu1 (2017, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. *******************Fruit and vegetables questions end*******************
. 
. 
. *Flu shot last year?
. *flushot (1993, 1995, 1997, 1999, 2001-2003): 1=Yes, 2=No, 7=Don’t know/not su
> re, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_data/2003/pdf/C
> odebook_03.pdf)
. *flushot2 (2004): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.gov/br
> fss/annual_data/2004/pdf/Codebook_04.pdf)
. *flushot3 (2005-2009): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.g
> ov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *flushot4 (2010): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *flushot5 (2011-2012): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *flushot6 (2013-2018): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *flushot7 (2019): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HT
> ML)
. 
. 
. *Seat belt usage
. *seatbelt (1993, 1995, 1997, 2002, 2006, 2008, 2010-2018): 1=Always, 2=Nearly 
> always, 3=Sometimes, 4=Seldom, 5=Never, 7=Don’t know/not sure, 8=Never drive o
> r ride in a car, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_da
> ta/2018/pdf/codebook18_llcp-v2-508.pdf)
. 
. 
. 
. *physical activities in last month:
. *exerany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *exerany2 (2001-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-508.p
> df)
. 
. 
. *medcost (Was there a time during the last 12 months when you needed to see a 
> doctor, but could not because of the cost?):
. *medcost (1993-2001, 2003-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused
>  (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. *healthcare plan (Do you have any kind of health care coverage, including heal
> th insurance, prepaid plans such as HMOs, or government plans such as Medicare
> ?):
. *hlthplan (1993-2010): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *hlthpln1 (2011-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. 
. *Medicare (Do you have Medicare?):
. *medicare (1996-1997): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 96/files/CODEBK96.TXT)
. *medicar2 (1998-2000): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 98/pdf/Codebook_98.pdf)
. 
. 
. *type of healthcare plan 1 (What type of health care coverage do you use to pa
> y for most of your medical care? Is it coverage through:):
. *typcovr1 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. *type of healthcare plan 2 (There are some types of coverage you may not have 
> considered. Please tell me if you have any of the following: (Only persons HLT
> HPLAN=2)):
. *typcovr2 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. 
. 
. *height:
. *htf (height in feet) (1993-2000): 2-6=Number of feet, 7=7 feet or Don't know/
> not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.p
> df)
. *htm (height in meters) (2001-2002): 999=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htm2 (height in meters) (2003): 999=Don't know/refused/missing (https://www.c
> dc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htm3 (height in meters) (2004-2010): 999=Don't know/refused/missing (https://
> www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htm4 (height in meters) (2011-2019) (https://www.cdc.gov/brfss/annual_data/20
> 11/pdf/CODEBOOK11_LLCP.pdf)
. *hti (height in inches) (1993-2000): 77=Don't know/not sure, 99=Refused (https
> ://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *htin (height in inches) (2001-2002): 99=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htin2 (height in inches) (2003): 999=Don't know/refused/missing (https://www.
> cdc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htin3 (height in inches) (2004-2010): 999=Don't know/refused/missing (https:/
> /www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htin4 (height in inches) (2011-2019) (https://www.cdc.gov/brfss/annual_data/2
> 011/pdf/CODEBOOK11_LLCP.pdf)
. *height (height in feet and inches, 3-digit number) (1993-2003): 777=Don't kno
> w/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebo
> ok_01.pdf)
. *height2 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches (<777), 4-digit number for meters and centimeters) (200
> 4): 777=Don't know/not sure, 999=Refused, 7777=Don't know/not sure, 9999=Refus
> ed, BLANK=Missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.
> pdf)
. *height3 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches, 4-digit number for meters and centimeters) (2005-2019)
> : 7777=Don't know/not sure, 9999=Refused, BLANK=Not asked/missing (https://www
> .cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. 
. 
. *weight:
. *weight (weight in pounds) (1993-2003): 777=Don't know/Not sure, 999=Refused (
> https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *weight2 (weight in pounds or kilograms) (2004-2019): 3-digit number for weigh
> t in pounds, 4-digit number for weight in kilograms, 777=Don't know/not sure, 
> 7777=Don't know/not sure, 9999=Refused (https://www.cdc.gov/brfss/annual_data/
> 2004/pdf/Codebook_04.pdf)
. 
. *education:
. *educa (1993-2019): 1=Never attended school/kindergarten only, 2=Elementary, 3
> =Some high school, 4=High school graduate, 5=Some college/technical school, 6=
> College graduate or more, 9=Refused (https://www.cdc.gov/brfss/annual_data/199
> 3/pdf/layout93.pdf)
. 
. 
. *income:
. *income (1993): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to 50K, 7=Over 50K, 
> 8=Don't know/not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/p
> df/layout93.pdf)
. *income (1994): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to less than 50K, 7=
> 50K to 75K, 8=Over 75K, 77=Don't know/not sure, 99=Refused (https://www.cdc.go
> v/brfss/annual_data/1994/pdf/layout94.pdf)
. *income95 (1995): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K to 24
> 999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't kno
> w/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout9
> 5.pdf)
. *income2 (1996-2019): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K t
> o 24999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't
>  know/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1996/files/C
> ODEBK96.TXT)
. 
. 
. *County:
. *ctycode (1993-2010): county code in numeric form
. *ctycode1 (2011-2012): county code in numeric form
. 
. 
. *The following state-years are missing (https://www.cdc.gov/brfss/annual_data/
> all_years/states_data.htm):
. *Wyoming (FIPS: 56): 1993 (This is not documented)
. *Rhode Island (FIPS: 44): 1994 (The documentation said that Rhode Island is mi
> ssing in 1993, but it is wrong)
. *Washington DC (FIPS: 11): 1995
. *Hawaii (FIPS: 15): 2004
. *New Jersey (FIPS: 34): 2019
. 
. 
. 
. 
. keep if _age80>=18 //make sure the minimum age is 18
(0 observations deleted)
r; t=0.05 5:03:21

. 
. 
. 
. *Health
. local new "srh"
r; t=0.00 5:03:21

. local old "genhlth"
r; t=0.00 5:03:21

. gen `new'=0 if `old'==5
(396,163 missing values generated)
r; t=0.07 5:03:21

. replace `new'=1 if `old'==4
(59,725 real changes made)
r; t=0.06 5:03:21

. replace `new'=2 if `old'==3
(133,631 real changes made)
r; t=0.06 5:03:21

. replace `new'=3 if `old'==2
(135,814 real changes made)
r; t=0.07 5:03:21

. replace `new'=4 if `old'==1
(65,946 real changes made)
r; t=0.07 5:03:22

. label var `new' "Self-rated health"
r; t=0.00 5:03:22

. label define `new' 0"Poor" 1"Fair" 2"Good" 3"VeryGood" 4"Excellent"
r; t=0.00 5:03:22

. numlabel `new', mask(#) add
r; t=1.56 5:03:23

. label value `new' `new'
r; t=0.01 5:03:23

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:23

. 
. 
. local new "badphyhlth"
r; t=0.00 5:03:23

. local old "physhlth"
r; t=0.00 5:03:23

. gen `new'=`old' if `old'<77
(262,901 missing values generated)
r; t=0.05 5:03:23

. replace `new'=0 if `old'==88
(252,492 real changes made)
r; t=0.05 5:03:23

. label var `new' "Number of days in last month with not good physical health"
r; t=0.00 5:03:23

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:23

. 
. 
. local new "badmenhlth"
r; t=0.00 5:03:23

. local old "menthlth"
r; t=0.00 5:03:23

. gen `new'=`old' if `old'<77
(276,116 missing values generated)
r; t=0.05 5:03:23

. replace `new'=0 if `old'==88
(267,337 real changes made)
r; t=0.05 5:03:23

. label var `new' "Number of days in last month with not good mental health"
r; t=0.00 5:03:23

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:23

. 
. 
. local new "actpoorhlth"
r; t=0.00 5:03:23

. local old "poorhlth"
r; t=0.00 5:03:23

. gen `new'=`old' if `old'<77
(317,590 missing values generated)
r; t=0.04 5:03:23

. replace `new'=0 if `old'==88
(122,140 real changes made)
r; t=0.02 5:03:23

. label var `new' "Number of days in last month keeping R from usual activities 
> due to poor physical/mental health"
note: label truncated to 80 characters
r; t=0.00 5:03:23

. note `new': Original: `old' | `tag'
r; t=0.01 5:03:23

. 
. 
. local new "asthmadiag"
r; t=0.00 5:03:23

. local old "asthma3"
r; t=0.00 5:03:23

. gen `new'=0 if `old'==2
(60,430 missing values generated)
r; t=0.09 5:03:23

. replace `new'=1 if `old'==1
(58,921 real changes made)
r; t=0.06 5:03:24

. label var `new' "Ever told you have asthma"
r; t=0.00 5:03:24

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:24

. numlabel `new', mask(#) add
r; t=1.67 5:03:25

. label value `new' `new'
r; t=0.00 5:03:25

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:25

. 
. 
. local new "cholesteroldiag"
r; t=0.00 5:03:25

. local old "toldhi2"
r; t=0.00 5:03:25

. gen `new'=0 if `old'==2
(173,203 missing values generated)
r; t=0.06 5:03:25

. replace `new'=1 if `old'==1
(144,170 real changes made)
r; t=0.03 5:03:25

. label var `new' "Ever told you have high cholesterol"
r; t=0.00 5:03:25

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:25

. numlabel `new', mask(#) add
r; t=1.52 5:03:27

. label value `new' `new'
r; t=0.00 5:03:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:27

. 
. 
. local new "heartattackdiag"
r; t=0.00 5:03:27

. local old "cvdinfr4"
r; t=0.00 5:03:27

. gen `new'=0 if `old'==2
(26,861 missing values generated)
r; t=0.06 5:03:27

. replace `new'=1 if `old'==1
(24,370 real changes made)
r; t=0.03 5:03:27

. label var `new' "Ever told you have heart attack"
r; t=0.00 5:03:27

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:27

. numlabel `new', mask(#) add
r; t=2.16 5:03:29

. label value `new' `new'
r; t=0.01 5:03:29

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:29

. 
. 
. local new "heartdiseasediag"
r; t=0.00 5:03:29

. local old "cvdcrhd4"
r; t=0.00 5:03:29

. gen `new'=0 if `old'==2
(27,448 missing values generated)
r; t=0.08 5:03:29

. replace `new'=1 if `old'==1
(23,438 real changes made)
r; t=0.02 5:03:29

. label var `new' "Ever told you have heart disease"
r; t=0.00 5:03:29

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:29

. numlabel `new', mask(#) add
r; t=2.30 5:03:31

. label value `new' `new'
r; t=0.01 5:03:31

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:31

. 
. 
. local new "strokediag"
r; t=0.00 5:03:31

. local old "cvdstrk3"
r; t=0.00 5:03:31

. gen `new'=0 if `old'==2
(20,055 missing values generated)
r; t=0.08 5:03:32

. replace `new'=1 if `old'==1
(18,745 real changes made)
r; t=0.01 5:03:32

. label var `new' "Ever told you have stroke"
r; t=0.00 5:03:32

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:32

. numlabel `new', mask(#) add
r; t=1.93 5:03:34

. label value `new' `new'
r; t=0.01 5:03:34

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:34

. 
. 
. local new "diabetesdiag"
r; t=0.00 5:03:34

. local old "diabete4"
r; t=0.00 5:03:34

. gen `new'=0 if `old'>=3 & `old'<=4
(62,028 missing values generated)
r; t=0.07 5:03:34

. replace `new'=1 if `old'==1
(57,401 real changes made)
r; t=0.02 5:03:34

. label var `new' "Ever told you have diabetes"
r; t=0.00 5:03:34

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:34

. numlabel `new', mask(#) add
r; t=1.54 5:03:35

. label value `new' `new'
r; t=0.00 5:03:35

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:35

. 
. 
. local new "highbloodpressurediag"
r; t=0.00 5:03:35

. local old "bphigh4"
r; t=0.00 5:03:35

. gen `new'=0 if `old'>=3 & `old'<=4
(174,278 missing values generated)
r; t=0.08 5:03:35

. replace `new'=1 if `old'==1
(169,634 real changes made)
r; t=0.05 5:03:35

. label var `new' "Ever told you have high blood pressure"
r; t=0.00 5:03:35

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:35

. numlabel `new', mask(#) add
r; t=1.53 5:03:37

. label value `new' `new'
r; t=0.01 5:03:37

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:37

. 
. 
. local new "actlim"
r; t=0.00 5:03:37

. local old "poorhlth"
r; t=0.00 5:03:37

. gen `new'=0 if `old'<14 | `old'==88 | physhlth==88 | menthlth==88
(28,022 missing values generated)
r; t=0.08 5:03:37

. replace `new'=1 if `old'>=14 & `old'<77 //14 days cutoff from (Dwyer-Lindgren 
> et al. 2017)
(39,074 real changes made)
r; t=0.02 5:03:37

. label var `new' "Frequent activity limitation"
r; t=0.00 5:03:37

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:37

. numlabel `new', mask(#) add
r; t=1.42 5:03:38

. label value `new' `new'
r; t=0.01 5:03:38

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:38

. 
. 
. local new "walkdiff"
r; t=0.00 5:03:38

. local old "diffwalk"
r; t=0.00 5:03:38

. gen `new'=2-`old' if `old'<7
(15,351 missing values generated)
r; t=0.06 5:03:38

. label var `new' "Difficulty walking or climbing stairs"
r; t=0.00 5:03:38

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:38

. numlabel `new', mask(#) add
r; t=1.45 5:03:40

. label value `new' `new'
r; t=0.00 5:03:40

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:40

. 
. 
. local new "dressdiff"
r; t=0.00 5:03:40

. local old "diffdres"
r; t=0.00 5:03:40

. gen `new'=2-`old' if `old'<7
(15,057 missing values generated)
r; t=0.12 5:03:40

. label var `new' "Difficulty dressing or bathing"
r; t=0.00 5:03:40

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:40

. numlabel `new', mask(#) add
r; t=1.66 5:03:42

. label value `new' `new'
r; t=0.01 5:03:42

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:42

. 
. 
. local new "erranddiffalone"
r; t=0.00 5:03:42

. local old "diffalon"
r; t=0.00 5:03:42

. gen `new'=2-`old' if `old'<7
(16,473 missing values generated)
r; t=0.07 5:03:42

. label var `new' "Difficulty doing errands alone (e.g., shopping, visit doctor)
> "
r; t=0.00 5:03:42

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:42

. numlabel `new', mask(#) add
r; t=1.71 5:03:43

. label value `new' `new'
r; t=0.00 5:03:43

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:43

. 
. 
. local new "funclimit"
r; t=0.00 5:03:43

. local old1 "actlim"
r; t=0.00 5:03:43

. local old2 "walkdiff"
r; t=0.00 5:03:43

. local old3 "dressdiff"
r; t=0.00 5:03:43

. local old4 "erranddiffalone"
r; t=0.00 5:03:43

. gen `new'=`old1' +`old2' + `old3' + `old4'
(21,989 missing values generated)
r; t=0.05 5:03:43

. label var `new' "Functional limitation index"
r; t=0.00 5:03:43

. note `new': Original: `old1' `old2' `old3' `old4' | `tag'
r; t=0.00 5:03:43

. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. *Health behaviors
. local new "bodycheck"
r; t=0.00 5:03:43

. local old "checkup1"
r; t=0.00 5:03:43

. gen `new'=5-`old' if `old'<=4
(7,272 missing values generated)
r; t=0.04 5:03:44

. replace `new'=0 if `old'==8
(2,452 real changes made)
r; t=0.01 5:03:44

. label var `new' "Last time did body check up"
r; t=0.00 5:03:44

. label define `new' 0"Never" 1"5orMoreYearsAgo" 2"2-5YearsAgo" 3"1-2YearsAgo" 4
> "1-12MonthsAgo"
r; t=0.00 5:03:44

. numlabel `new', mask(#_) add
r; t=1.76 5:03:45

. label value `new' `new'
r; t=0.00 5:03:45

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:45

. 
. 
. local new "alcoholnum"
r; t=0.00 5:03:45

. local old "alcday5"
r; t=0.00 5:03:45

. gen `new'=(`old'-100)/7 if `old'>=100 & `old'<=107
(364,280 missing values generated)
r; t=0.04 5:03:45

. replace `new'=(`old'-200)/30 if `old'>=201 & `old'<=230
(145,800 real changes made)
r; t=0.05 5:03:45

. replace `new'=0 if `old'==888
(195,326 real changes made)
r; t=0.04 5:03:45

. label var `new' "Average number of days of alcohol drinking in last month"
r; t=0.00 5:03:45

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:45

. 
. 
. local new "bingedrink"
r; t=0.00 5:03:45

. local old "_rfbing5"
r; t=0.00 5:03:45

. gen `new'=`old'-1 if `old'<9
(28,070 missing values generated)
r; t=0.08 5:03:46

. label var `new' "Binge drinking in last 30 days"
r; t=0.00 5:03:46

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:46

. numlabel `new', mask(#) add
r; t=1.61 5:03:47

. label value `new' `new'
r; t=0.01 5:03:47

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:47

. 
. 
. local new "heavydrink"
r; t=0.00 5:03:47

. local old "_rfdrhv7"
r; t=0.00 5:03:47

. gen `new'=`old'-1 if `old'<9
(27,699 missing values generated)
r; t=0.08 5:03:47

. label var `new' "Heavy drinking in last 30 days"
r; t=0.00 5:03:47

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:47

. numlabel `new', mask(#) add
r; t=2.22 5:03:49

. label value `new' `new'
r; t=0.01 5:03:49

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:49

. 
. 
. 
. local new "smokeever"
r; t=0.00 5:03:49

. local old "smoke100"
r; t=0.00 5:03:49

. gen `new'=0 if `old'==2
(187,132 missing values generated)
r; t=0.09 5:03:50

. replace `new'=1 if `old'==1
(168,593 real changes made)
r; t=0.06 5:03:50

. label var `new' "Ever smoke at least 100 cigarettes in life"
r; t=0.00 5:03:50

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:50

. numlabel `new', mask(#) add
r; t=2.51 5:03:52

. label value `new' `new'
r; t=0.01 5:03:52

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:52

. 
. 
. local new "smoking"
r; t=0.00 5:03:52

. local old "smokday2"
r; t=0.00 5:03:52

. gen `new'=0 if smokeever==0
(187,132 missing values generated)
r; t=0.09 5:03:52

. replace `new'=1 if `old'==3 & smokeever==1
(111,782 real changes made)
r; t=0.06 5:03:52

. replace `new'=2 if `old'==2
(16,266 real changes made)
r; t=0.05 5:03:52

. replace `new'=3 if `old'==1
(40,156 real changes made)
r; t=0.03 5:03:52

. label var `new' "How often smoke cigarettes"
r; t=0.00 5:03:52

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeDays" 3"Everyday"
r; t=0.00 5:03:52

. numlabel `new', mask(#) add
r; t=2.22 5:03:55

. label value `new' `new'
r; t=0.00 5:03:55

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:55

. 
. 
. local new "smokingsim"
r; t=0.00 5:03:55

. local old "smoking"
r; t=0.00 5:03:55

. gen `new'=0 if `old'==0
(187,132 missing values generated)
r; t=0.08 5:03:55

. replace `new'=1 if `old'==1
(111,782 real changes made)
r; t=0.06 5:03:55

. replace `new'=2 if `old'==2 | `old'==3
(56,422 real changes made)
r; t=0.06 5:03:55

. label var `new' "How often smoke cigarettes"
r; t=0.01 5:03:55

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeorEveryDay"
r; t=0.00 5:03:55

. numlabel `new', mask(#) add
r; t=1.57 5:03:56

. label value `new' `new'
r; t=0.01 5:03:56

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:56

. 
. 
. local new "vegserv" //this variable includes dark green vegetables, french fri
> es, potato, and other vegetables intake
r; t=0.00 5:03:56

. local old "_vegesu1"
r; t=0.00 5:03:56

. gen `new'=`old'/100 if _vegete1==0 //exclude those who reported 24 servings or
>  more per day (too high, according to official codebook)
(54,394 missing values generated)
r; t=0.05 5:03:56

. label var `new' "Vegetables servings per day"
r; t=0.00 5:03:56

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:56

. 
. 
. local new "veg1perday"
r; t=0.00 5:03:56

. local old "vegserv"
r; t=0.00 5:03:56

. gen `new'=0 if `old'<1
(348,453 missing values generated)
r; t=0.03 5:03:56

. replace `new'=1 if `old'>=1 & !mi(`old')
(294,059 real changes made)
r; t=0.02 5:03:56

. label var `new' "1 or more vegetables servings per day"
r; t=0.00 5:03:56

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:56

. numlabel `new', mask(#) add
r; t=1.62 5:03:58

. label value `new' `new'
r; t=0.01 5:03:58

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:58

. 
. 
. local new "greenvegserv"
r; t=0.00 5:03:58

. local old "grenda1_"
r; t=0.00 5:03:58

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(39,473 missing values generated)
r; t=0.06 5:03:58

. label var `new' "Dark green vegetables servings per day"
r; t=0.00 5:03:58

. note `new': Original: `old' | `tag'
r; t=0.00 5:03:58

. 
. 
. local new "greenveg1perday"
r; t=0.00 5:03:58

. local old "greenvegserv"
r; t=0.00 5:03:58

. gen `new'=0 if `old'<1
(126,813 missing values generated)
r; t=0.06 5:03:58

. replace `new'=1 if `old'>=1 & !mi(`old')
(87,340 real changes made)
r; t=0.02 5:03:58

. label var `new' "1 or more green vegetables servings per day"
r; t=0.00 5:03:58

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:03:58

. numlabel `new', mask(#) add
r; t=1.74 5:04:00

. label value `new' `new'
r; t=0.01 5:04:00

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:00

. 
. 
. local new "friesserv"
r; t=0.00 5:04:00

. local old "frnchda_"
r; t=0.00 5:04:00

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(39,016 missing values generated)
r; t=0.06 5:04:00

. label var `new' "French fries servings per day"
r; t=0.00 5:04:00

. note `new': Original: `old' | `tag'
r; t=0.01 5:04:00

. 
. 
. local new "fries1perday"
r; t=0.00 5:04:00

. local old "friesserv"
r; t=0.00 5:04:00

. gen `new'=0 if `old'<1
(53,350 missing values generated)
r; t=0.06 5:04:00

. replace `new'=1 if `old'>=1 & !mi(`old')
(14,334 real changes made)
r; t=0.02 5:04:00

. label var `new' "1 or more french fries servings per day"
r; t=0.00 5:04:00

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:00

. numlabel `new', mask(#) add
r; t=1.69 5:04:02

. label value `new' `new'
r; t=0.01 5:04:02

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:02

. 
. 
. local new "potatoserv"
r; t=0.00 5:04:02

. local old "potada1_"
r; t=0.00 5:04:02

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(42,397 missing values generated)
r; t=0.06 5:04:02

. label var `new' "Potato servings per day"
r; t=0.00 5:04:02

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:02

. 
. 
. local new "potato1perday"
r; t=0.00 5:04:02

. local old "potatoserv"
r; t=0.00 5:04:02

. gen `new'=0 if `old'<1
(58,873 missing values generated)
r; t=0.07 5:04:02

. replace `new'=1 if `old'>=1 & !mi(`old')
(16,476 real changes made)
r; t=0.02 5:04:02

. label var `new' "1 or more potato servings per day"
r; t=0.00 5:04:02

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:02

. numlabel `new', mask(#) add
r; t=1.72 5:04:04

. label value `new' `new'
r; t=0.02 5:04:04

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:04

. 
. 
. local new "othvegserv"
r; t=0.00 5:04:04

. local old "vegeda2_"
r; t=0.00 5:04:04

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(44,268 missing values generated)
r; t=0.06 5:04:04

. label var `new' "Other vegetables servings per day"
r; t=0.00 5:04:04

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:04

. 
. 
. local new "otherveg1perday"
r; t=0.00 5:04:04

. local old "othvegserv"
r; t=0.00 5:04:04

. gen `new'=0 if `old'<1
(228,591 missing values generated)
r; t=0.05 5:04:04

. replace `new'=1 if `old'>=1 & !mi(`old')
(184,323 real changes made)
r; t=0.02 5:04:04

. label var `new' "1 or more other vegetables servings per day"
r; t=0.00 5:04:04

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:04

. numlabel `new', mask(#) add
r; t=1.58 5:04:05

. label value `new' `new'
r; t=0.00 5:04:05

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:05

. 
. 
. local new "totalfruitserv" //this variable includes fruit juice and fruit inta
> ke
r; t=0.00 5:04:05

. local old "frutda2_"
r; t=0.00 5:04:05

. gen `new'=`old'/100 if _vegete1==0 //exclude those who reported 17 servings or
>  more per day (too high, according to official codebook)
(58,391 missing values generated)
r; t=0.05 5:04:05

. label var `new' "Total fruit servings per day"
r; t=0.00 5:04:05

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:05

. 
. 
. local new "totalfruit1perday"
r; t=0.00 5:04:05

. local old "totalfruitserv"
r; t=0.00 5:04:05

. gen `new'=0 if `old'<1
(256,238 missing values generated)
r; t=0.05 5:04:06

. replace `new'=1 if `old'>=1 & !mi(`old')
(197,847 real changes made)
r; t=0.02 5:04:06

. label var `new' "1 or more total fruit servings per day"
r; t=0.00 5:04:06

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:06

. numlabel `new', mask(#) add
r; t=1.58 5:04:07

. label value `new' `new'
r; t=0.01 5:04:07

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:07

. 
. 
. local new "fruitjuiceserv"
r; t=0.00 5:04:07

. local old "ftjuda2_"
r; t=0.00 5:04:07

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(38,451 missing values generated)
r; t=0.06 5:04:07

. label var `new' "Fruit juice servings per day"
r; t=0.01 5:04:07

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:07

. 
. 
. local new "fruitjuice1perday"
r; t=0.00 5:04:07

. local old "fruitjuiceserv"
r; t=0.00 5:04:07

. gen `new'=0 if `old'<1
(99,381 missing values generated)
r; t=0.06 5:04:07

. replace `new'=1 if `old'>=1 & !mi(`old')
(60,930 real changes made)
r; t=0.03 5:04:07

. label var `new' "1 or more fruit juice servings per day"
r; t=0.00 5:04:07

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:07

. numlabel `new', mask(#) add
r; t=1.55 5:04:09

. label value `new' `new'
r; t=0.00 5:04:09

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:09

. 
. 
. local new "fruitserv"
r; t=0.00 5:04:09

. local old "frutda2_"
r; t=0.00 5:04:09

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(39,031 missing values generated)
r; t=0.09 5:04:09

. label var `new' "Fruit servings per day"
r; t=0.00 5:04:09

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:09

. 
. 
. local new "fruit1perday"
r; t=0.00 5:04:09

. local old "fruitserv"
r; t=0.00 5:04:09

. gen `new'=0 if `old'<1
(247,310 missing values generated)
r; t=0.09 5:04:09

. replace `new'=1 if `old'>=1 & !mi(`old')
(208,279 real changes made)
r; t=0.08 5:04:09

. label var `new' "1 or more fruit servings per day"
r; t=0.00 5:04:09

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:09

. numlabel `new', mask(#) add
r; t=2.32 5:04:11

. label value `new' `new'
r; t=0.02 5:04:11

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:11

. 
. 
. local new "weightinkg"
r; t=0.00 5:04:11

. local old "weight2"
r; t=0.00 5:04:11

. gen `new'=`old'*0.45359237 if `old'<777
(30,883 missing values generated)
r; t=0.100 5:04:12

. replace `new'=`old'-9000 if `old'>7777 & `old'<9999
(1,149 real changes made)
r; t=0.05 5:04:13

. label var `new' "Weight (kg)"
r; t=0.00 5:04:13

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:13

. 
. 
. local new "heightinmeter"
r; t=0.00 5:04:13

. local old "height3"
r; t=0.00 5:04:13

. gen `new'=real(substr(string(`old'), 1, 1))/3.2808+real(substr(string(`old'), 
> 2, 2))/39.37 if `old'<777
(20,353 missing values generated)
r; t=0.61 5:04:13

. replace `new'=(`old'-9000)/100 if `old'>7777 & `old'<9230
(1,617 real changes made)
r; t=0.05 5:04:13

. label var `new' "Height (m)"
r; t=0.00 5:04:13

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:13

. 
. 
. local new "bmi"
r; t=0.00 5:04:13

. local old "_bmi5"
r; t=0.00 5:04:13

. gen `new'=`old'/100 if !mi(`old')
(36,203 missing values generated)
r; t=0.11 5:04:13

. label var `new' "Body mass index"
r; t=0.00 5:04:13

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:13

. 
. 
. local new "bmicat"
r; t=0.00 5:04:13

. local old "_bmi5cat"
r; t=0.00 5:04:13

. gen `new'=`old'-1 if `old'<=4
(36,203 missing values generated)
r; t=0.12 5:04:13

. label var `new' "BMI category"
r; t=0.00 5:04:13

. label define `new' 0"Underweight" 1"Normal" 2"Overweight" 3"Obese"
r; t=0.00 5:04:13

. numlabel `new', mask(#) add
r; t=2.09 5:04:16

. label value `new' `new'
r; t=0.00 5:04:16

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:16

. 
. 
. local new "hivrisk"
r; t=0.00 5:04:16

. local old "hivrisk5"
r; t=0.00 5:04:16

. gen `new'=0 if `old'==2
(59,926 missing values generated)
r; t=0.07 5:04:16

. replace `new'=1 if `old'==1
(15,987 real changes made)
r; t=0.03 5:04:16

. label var `new' "High HIV risk behaviors last year"
r; t=0.00 5:04:16

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:16

. numlabel `new', mask(#) add
r; t=1.58 5:04:17

. label value `new' `new'
r; t=0.00 5:04:17

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:17

. 
. 
. 
. 
. 
. 
. 
. *Physical activity
. local new "exercise"
r; t=0.00 5:04:17

. local old "exerany2"
r; t=0.00 5:04:17

. gen `new'=0 if `old'==2
(310,523 missing values generated)
r; t=0.06 5:04:17

. replace `new'=1 if `old'==1
(288,516 real changes made)
r; t=0.07 5:04:17

. label var `new' "Any exercise (except regular job) last month"
r; t=0.00 5:04:17

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:04:17

. numlabel `new', mask(#) add
r; t=1.58 5:04:19

. label value `new' `new'
r; t=0.00 5:04:19

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:19

. 
. 
. local new "exercise1type"
r; t=0.00 5:04:19

. local old "exract11"
r; t=0.00 5:04:19

. gen `new'=`old' if `old'<77
(150,347 missing values generated)
r; t=0.07 5:04:19

. label var `new' "Type of physical activity"
r; t=0.00 5:04:19

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:19

. 
. 
. local new "exercise1freq"
r; t=0.00 5:04:19

. local old "exeroft1"
r; t=0.00 5:04:19

. gen `new'=`old' if `old'>=101 & `old'<=199
(231,061 missing values generated)
r; t=0.08 5:04:19

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(90,545 real changes made)
r; t=0.05 5:04:19

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 5:04:19

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:19

. 
. 
. local new "exercise1min"
r; t=0.00 5:04:19

. local old "exerhmm1"
r; t=0.00 5:04:19

. gen `new'=`old' if `old'<100
(280,063 missing values generated)
r; t=0.07 5:04:19

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(135,981 real changes made)
r; t=0.06 5:04:19

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 5:04:19

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:19

. 
. 
. local new "exercise2type"
r; t=0.00 5:04:19

. local old "exract21"
r; t=0.00 5:04:19

. gen `new'=`old' if `old'<77
(256,024 missing values generated)
r; t=0.10 5:04:19

. label var `new' "Type of physical activity"
r; t=0.00 5:04:19

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:19

. 
. 
. local new "exercise2freq"
r; t=0.00 5:04:19

. local old "exeroft2"
r; t=0.00 5:04:19

. gen `new'=`old' if `old'>=101 & `old'<=199
(304,241 missing values generated)
r; t=0.08 5:04:19

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(66,711 real changes made)
r; t=0.06 5:04:20

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 5:04:20

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:20

. 
. 
. local new "exercise2min"
r; t=0.00 5:04:20

. local old "exerhmm2"
r; t=0.00 5:04:20

. gen `new'=`old' if `old'<100
(332,908 missing values generated)
r; t=0.07 5:04:20

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(92,900 real changes made)
r; t=0.06 5:04:20

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 5:04:20

. note `new': Original: `old' | `tag'
r; t=0.00 5:04:20

. 
. 
. local new "muscleexercise"
r; t=0.00 5:04:20

. local old "strength"
r; t=0.00 5:04:20

. gen `new'=`old' if `old'>=101 & `old'<=199
(307,265 missing values generated)
r; t=0.08 5:04:20

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(61,544 real changes made)
r; t=0.04 5:04:20

. label var `new' "Frequency of muscle-strengthening exercise (times per week)"
r; t=0.00 5:04:20

. note `new': Original: `old' | `tag'
r; t=0.01 5:04:20

. 
. 
. local new "exe_total_min"
r; t=0.00 5:04:20

. local old1 "pa2min_"
r; t=0.00 5:04:20

. local old2 "exercise"
r; t=0.00 5:04:20

. gen `new'=`old1' if !mi(`old1')
(140,384 missing values generated)
r; t=0.08 5:04:20

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.03 5:04:20

. label var `new' "Minutes of the two reported exercises per week (last month)"
r; t=0.00 5:04:20

. note `new': Original: `old1' `old2' | `tag'
r; t=0.01 5:04:20

. 
. 
. local new "exe1_intensity"
r; t=0.00 5:04:20

. local old1 "actin12_"
r; t=0.00 5:04:20

. local old2 "exercise"
r; t=0.00 5:04:20

. gen `new'=`old1'+1
(135,951 missing values generated)
r; t=0.07 5:04:20

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.05 5:04:20

. label var `new' "Intensity of 1st reported type of exercise in last month"
r; t=0.00 5:04:20

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 5:04:20

. numlabel `new', mask(#) add
r; t=1.71 5:04:22

. label value `new' `new'
r; t=0.00 5:04:22

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:22

. 
. 
. local new "exe2_intensity"
r; t=0.00 5:04:22

. local old1 "actin22_"
r; t=0.00 5:04:22

. local old2 "exercise"
r; t=0.00 5:04:22

. gen `new'=`old1'+1 //Note that respondents who reported only the 1st but not 2
> nd exercise are coded as missing
(143,575 missing values generated)
r; t=0.07 5:04:22

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.04 5:04:22

. label var `new' "Intensity of 2nd reported type of exercise in last month"
r; t=0.00 5:04:22

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 5:04:22

. numlabel `new', mask(#) add
r; t=2.29 5:04:24

. label value `new' `new'
r; t=0.01 5:04:24

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:24

. 
. 
. local new "exe_intensity"
r; t=0.00 5:04:24

. local old1 "exe1_intensity"
r; t=0.00 5:04:24

. local old2 "exe2_intensity"
r; t=0.00 5:04:24

. gen `new'=0 if `old1'==0 & `old2'==0
(310,523 missing values generated)
r; t=0.07 5:04:24

. replace `new'=1 if `old1'==1 & mi(`old2')
(291 real changes made)
r; t=0.05 5:04:24

. replace `new'=2 if `old1'==2 & mi(`old2')
(5,032 real changes made)
r; t=0.04 5:04:24

. replace `new'=3 if `old1'==3 & mi(`old2')
(2,310 real changes made)
r; t=0.05 5:04:24

. replace `new'=4 if `old1'==1 & `old2'==1
(3,167 real changes made)
r; t=0.05 5:04:24

. replace `new'=5 if (`old1'==1 & `old2'==2) | (`old1'==2 & `old2'==1)
(89,080 real changes made)
r; t=0.07 5:04:24

. replace `new'=6 if (`old1'==1 & `old2'==3) | (`old1'==3 & `old2'==1)
(37,113 real changes made)
r; t=0.07 5:04:25

. replace `new'=7 if `old1'==2 & `old2'==2
(52,138 real changes made)
r; t=0.06 5:04:25

. replace `new'=8 if (`old1'==2 & `old2'==3) | (`old1'==3 & `old2'==2)
(57,237 real changes made)
r; t=0.08 5:04:25

. replace `new'=9 if `old1'==3 & `old2'==3
(35,947 real changes made)
r; t=0.06 5:04:25

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 5:04:25

. label define `new' 0"NoExercise" 1"OneLightEx" 2"OneModEx" 3"OneVigEx" 4"TwoLi
> ghtEx" ///
> 5"Light&ModEx" 6"Light&VigEx" 7"TwoModEx" 8"Mod&VigEx" 9"TwoVigEx"
r; t=0.00 5:04:25

. numlabel `new', mask(#) add
r; t=1.96 5:04:27

. label value `new' `new'
r; t=0.01 5:04:27

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:27

. 
. 
. local new "exe_intensity_sim"
r; t=0.00 5:04:27

. local old "exe_intensity"
r; t=0.00 5:04:27

. gen `new'=0 if `old'==0
(310,523 missing values generated)
r; t=0.09 5:04:27

. replace `new'=1 if `old'>=1 & `old'<=4
(10,800 real changes made)
r; t=0.07 5:04:27

. replace `new'=2 if `old'==5
(89,080 real changes made)
r; t=0.07 5:04:27

. replace `new'=3 if `old'==6
(37,113 real changes made)
r; t=0.07 5:04:27

. replace `new'=4 if `old'==7
(52,138 real changes made)
r; t=0.07 5:04:27

. replace `new'=5 if `old'==8
(57,237 real changes made)
r; t=0.07 5:04:27

. replace `new'=6 if `old'==9
(35,947 real changes made)
r; t=0.07 5:04:27

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 5:04:27

. label define `new' 0"NoExercise" 1"OneExOrTwoLight" 2"Light&ModEx" 3"Light&Vig
> Ex" 4"TwoModEx" 5"Mod&VigEx" 6"TwoVigEx"
r; t=0.00 5:04:27

. numlabel `new', mask(#) add
r; t=2.62 5:04:30

. label value `new' `new'
r; t=0.02 5:04:30

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:30

. 
. 
. local new "exe_intensity_simplest"
r; t=0.00 5:04:30

. local old "exe_intensity_sim"
r; t=0.00 5:04:30

. gen `new'=0 if `old'==0
(310,523 missing values generated)
r; t=0.10 5:04:30

. replace `new'=1 if `old'>=1 & `old'<=4
(189,131 real changes made)
r; t=0.09 5:04:30

. replace `new'=2 if `old'==5
(57,237 real changes made)
r; t=0.08 5:04:30

. replace `new'=3 if `old'==6
(35,947 real changes made)
r; t=0.09 5:04:30

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 5:04:30

. label define `new' 0"NoExercise" 1"TwoModExOrBelow" 2"Mod&VigEx" 3"TwoVigEx"
r; t=0.00 5:04:30

. numlabel `new', mask(#) add
r; t=2.82 5:04:33

. label value `new' `new'
r; t=0.01 5:04:33

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:33

. 
. 
. 
. local new "exe1_freq"
r; t=0.00 5:04:33

. local old1 "pafreq1_"
r; t=0.00 5:04:33

. local old2 "exercise"
r; t=0.00 5:04:33

. gen `new'=`old1'/1000 if !mi(`old1')
(140,516 missing values generated)
r; t=0.13 5:04:33

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.07 5:04:33

. replace `new'=. if `old1'==99000
(34 real changes made, 34 to missing)
r; t=0.07 5:04:33

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 5:04:33

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:33

. 
. 
. local new "exe2_freq"
r; t=0.00 5:04:33

. local old1 "pafreq2_"
r; t=0.00 5:04:33

. local old2 "exercise"
r; t=0.00 5:04:33

. local old3 "exe2_intensity"
r; t=0.00 5:04:33

. gen `new'=`old1'/1000 if !mi(`old1')
(237,530 missing values generated)
r; t=0.17 5:04:33

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(143,575 real changes made)
r; t=0.09 5:04:34

. replace `new'=. if `old1'==99000
(25 real changes made, 25 to missing)
r; t=0.07 5:04:34

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 5:04:34

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 5:04:34

. 
. 
. local new "exe1_min_per_week"
r; t=0.00 5:04:34

. local old1 "_minac11"
r; t=0.00 5:04:34

. local old2 "exercise"
r; t=0.00 5:04:34

. gen `new'=`old1' if !mi(`old1')
(146,930 missing values generated)
r; t=0.14 5:04:34

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(316 real changes made)
r; t=0.08 5:04:34

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.09 5:04:34

. label var `new' "Minutes of 1st reported type of exercise per week (last month
> )"
r; t=0.00 5:04:34

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:04:34

. 
. 
. xtile exe1_min_quartile=exe1_min_per_week, nq(4)
r; t=3.53 5:04:37

. xtile exe1_min_quintile=exe1_min_per_week, nq(5)
r; t=3.82 5:04:41

. xtile exe1_min_sextile=exe1_min_per_week, nq(6)
r; t=4.06 5:04:45

. xtile exe1_min_dectile=exe1_min_per_week, nq(10)
r; t=4.88 5:04:50

. 
. 
. local new "exe2_min_per_week"
r; t=0.00 5:04:50

. local old1 "_minac21"
r; t=0.00 5:04:50

. local old2 "exercise"
r; t=0.00 5:04:50

. local old3 "exe2_intensity"
r; t=0.00 5:04:50

. gen `new'=`old1' if !mi(`old1')
(147,892 missing values generated)
r; t=0.14 5:04:50

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(307 real changes made)
r; t=0.08 5:04:50

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(141,871 real changes made)
r; t=0.09 5:04:51

. label var `new' "Minutes of 2nd reported type of exercise per week (last month
> )"
r; t=0.00 5:04:51

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 5:04:51

. 
. xtile exe2_min_quartile=exe2_min_per_week, nq(4)
r; t=5.30 5:04:56

. xtile exe2_min_quintile=exe2_min_per_week, nq(5)
r; t=3.50 5:04:59

. xtile exe2_min_sextile=exe2_min_per_week, nq(6)
r; t=3.69 5:05:03

. xtile exe2_min_dectile=exe2_min_per_week, nq(10)
r; t=3.80 5:05:07

. 
. 
. local new "strength_exe_freq"
r; t=0.00 5:05:07

. local old "strfreq_"
r; t=0.00 5:05:07

. gen `new'=`old'/1000
(37,082 missing values generated)
r; t=0.08 5:05:07

. replace `new'=. if `old'==99000
(31 real changes made, 31 to missing)
r; t=0.05 5:05:07

. label var `new' "Frequency of muscle strengthening exercise (times per week, l
> ast month)"
r; t=0.00 5:05:07

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:07

. 
. xtile strength_time_tertile=strength_exe_freq, nq(3) //only tertile can be cal
> culated since the variable's distribution is very sparse.
r; t=3.87 5:05:11

. 
. 
. 
. 
. local new "exe_vigeq_min_per_week"
r; t=0.00 5:05:11

. local old1 "pa2min_"
r; t=0.00 5:05:11

. local old2 "exercise"
r; t=0.00 5:05:11

. gen `new'=`old1' if !mi(`old1')
(140,384 missing values generated)
r; t=0.14 5:05:11

. replace `new'=0 if `old2'==0
(107,745 real changes made)
r; t=0.08 5:05:11

. label var `new' "Vigorous equivalent minutes of exercise per week (last month)
> "
r; t=0.00 5:05:11

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:05:11

. 
. 
. local new "exe_vig_min_per_week"
r; t=0.00 5:05:11

. local old1 "pa2vigm_"
r; t=0.00 5:05:11

. local old2 "exercise"
r; t=0.00 5:05:11

. gen `new'=`old1' if !mi(`old1')
(137,642 missing values generated)
r; t=0.13 5:05:11

. replace `new'=0 if `old2'==0
(107,744 real changes made)
r; t=0.08 5:05:11

. label var `new' "Vigorous minutes of exercise per week (last month)"
r; t=0.00 5:05:11

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:05:11

. 
. 
. local new "exe_active" //Note: this variable is not recommended to be used sin
> ce respondents who only reported 1 type of exercise (about 2524) were excluded
>  due to lack of data to classify their overall exercise time per week
r; t=0.00 5:05:11

. local old "_pacat2"
r; t=0.00 5:05:11

. gen `new'=4-`old' if `old'<9
(49,135 missing values generated)
r; t=0.14 5:05:11

. label var `new' "Sufficient exercise per week in last month"
r; t=0.00 5:05:11

. label define `new' 0"Inactive" 1"InsufficientlyActive" 2"Active" 3"HighlyActiv
> e"
r; t=0.00 5:05:11

. numlabel `new', mask(#) add
r; t=2.56 5:05:14

. label value `new' `new'
r; t=0.01 5:05:14

. note `new': Original: `old' Exercise per week guideline reference: https://www
> .ncbi.nlm.nih.gov/books/NBK566046/ | `tag'
r; t=0.00 5:05:14

. 
. 
. local new "exe_aerobic_advice"
r; t=0.00 5:05:14

. local old "_pa150r3"
r; t=0.00 5:05:14

. gen `new'=3-`old' if `old'<9
(50,601 missing values generated)
r; t=0.16 5:05:14

. label var `new' "Meet aerobic exercise recommendations (150+ min per week) las
> t month"
r; t=0.00 5:05:14

. label define `new' 0"NoAerobicExercise" 1"Under149MinEx" 2"150+MinEx"
r; t=0.00 5:05:14

. numlabel `new', mask(#) add
r; t=1.99 5:05:16

. label value `new' `new'
r; t=0.01 5:05:16

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:16

. 
. 
. local new "exe_strength_advice"
r; t=0.00 5:05:16

. local old "_pastrng"
r; t=0.00 5:05:16

. gen `new'=2-`old' if `old'<9
(37,082 missing values generated)
r; t=0.11 5:05:16

. label var `new' "Meet muscle strengthening recommendations (at least 2 times p
> er week) last month"
r; t=0.00 5:05:16

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:05:16

. numlabel `new', mask(#) add
r; t=1.69 5:05:18

. label value `new' `new'
r; t=0.00 5:05:18

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:18

. 
. 
. local new "exe_aero_strength_advice"
r; t=0.00 5:05:18

. local old "_parec2"
r; t=0.00 5:05:18

. gen `new'=4-`old' if `old'<9
(55,927 missing values generated)
r; t=0.12 5:05:18

. label var `new' "Meet areobic and muscle strengthening recommendations last mo
> nth"
r; t=0.00 5:05:18

. label define `new' 0"Neither" 1"StrengtheningOnly" 2"AerobicOnly" 3"Both"
r; t=0.00 5:05:18

. numlabel `new', mask(#) add
r; t=1.78 5:05:20

. label value `new' `new'
r; t=0.01 5:05:20

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:20

. 
. 
. local new "metval1"
r; t=0.00 5:05:20

. local old1 "metvl11_"
r; t=0.00 5:05:20

. local old2 "exercise"
r; t=0.00 5:05:20

. gen `new'=`old1' if `old1'<=128
(131,817 missing values generated)
r; t=0.10 5:05:20

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(107,745 real changes made)
r; t=0.06 5:05:20

. label var `new' "Metabolic equivalents (METs) of the 1st reported exercise"
r; t=0.00 5:05:20

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:05:20

. 
. 
. local new "metval2"
r; t=0.00 5:05:20

. local old1 "metvl11_"
r; t=0.00 5:05:20

. local old2 "exercise"
r; t=0.00 5:05:20

. gen `new'=`old1' if `old1'<=128
(131,817 missing values generated)
r; t=0.10 5:05:20

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(107,745 real changes made)
r; t=0.07 5:05:20

. label var `new' "Metabolic equivalents (METs) of the 2nd reported exercise"
r; t=0.00 5:05:20

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 5:05:20

. 
. 
. local new "metval_avg"
r; t=0.00 5:05:20

. local old1 "metval1"
r; t=0.00 5:05:20

. local old2 "metval2"
r; t=0.00 5:05:20

. gen `new'=(`old1'+`old2')/2
(24,074 missing values generated)
r; t=0.06 5:05:20

. label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
r; t=0.00 5:05:20

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:20

. 
. 
. /*
> local new "metval_quartile"
> local old "metval_avg"
> xtile `new'=`old', nq(4)
> label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
> label define `new' 1"1stQuartile" 2"2ndQuartile" 3"3rdQuartile" 4"4thQuartile"
> numlabel `new', mask(#) add
> label value `new' `new'
> local ivarlist `ivarlist' `new'
> note `new': Original: `old' | `tag'
> */
. 
. 
. 
. 
. *Healthcare
. local new "afforddoc"
r; t=0.00 5:05:20

. local old "medcost"
r; t=0.00 5:05:20

. gen `new'=0 if `old'==2
(45,585 missing values generated)
r; t=0.10 5:05:20

. replace `new'=1 if `old'==1
(44,377 real changes made)
r; t=0.06 5:05:20

. label var `new' "Cannot see doc due to cost in last 12 months"
r; t=0.00 5:05:20

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:05:20

. numlabel `new', mask(#) add
r; t=1.88 5:05:22

. label value `new' `new'
r; t=0.01 5:05:22

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:22

. 
. 
. local new "hlthcare"
r; t=0.00 5:05:22

. local old "hlthpln1"
r; t=0.00 5:05:22

. gen `new'=0 if `old'==2
(382,599 missing values generated)
r; t=0.08 5:05:22

. replace `new'=1 if `old'==1
(380,524 real changes made)
r; t=0.09 5:05:22

. label var `new' "Any healthcare coverage (either private or public)?"
r; t=0.00 5:05:22

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:05:22

. numlabel `new', mask(#) add
r; t=1.93 5:05:24

. label value `new' `new'
r; t=0.00 5:05:24

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:24

. 
. 
. local new "hlthcare1864"
r; t=0.00 5:05:24

. local old "_hcvu651"
r; t=0.00 5:05:24

. gen `new'=0 if `old'==2
(385,536 missing values generated)
r; t=0.11 5:05:25

. replace `new'=1 if `old'==1
(225,081 real changes made)
r; t=0.09 5:05:25

. label var `new' "Any healthcare coverage? (18-64 years old only)"
r; t=0.01 5:05:25

. label define `new' 0"No" 1"Yes"
r; t=0.00 5:05:25

. numlabel `new', mask(#) add
r; t=1.89 5:05:27

. label value `new' `new'
r; t=0.02 5:05:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:27

. 
. 
. 
. 
. 
. *Sociodemographic variables
. local new "oxygen_max"
r; t=0.00 5:05:27

. local old "maxvo21_"
r; t=0.00 5:05:27

. gen `new'=`old'/100 if `old'<99900
(6,688 missing values generated)
r; t=0.15 5:05:27

. label var `new' "Estimated Maximum Oxygen Consumption (mL/kg/min)"
r; t=0.00 5:05:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:27

. 
. 
. local new "yearsold"
r; t=0.00 5:05:27

. local old "_age80"
r; t=0.00 5:05:27

. gen `new'=`old' if `old'<=80
r; t=0.11 5:05:27

. label var `new' "Age"
r; t=0.00 5:05:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:27

. 
. 
. 
. local new "agegroup"
r; t=0.00 5:05:27

. local old "yearsold"
r; t=0.00 5:05:27

. gen `new'=0 if `old'>=18 & `old'<=20
(408,122 missing values generated)
r; t=0.07 5:05:27

. replace `new'=1 if `old'>=21 & `old'<=25
(18,981 real changes made)
r; t=0.06 5:05:27

. replace `new'=2 if `old'>=26 & `old'<=30
(21,677 real changes made)
r; t=0.06 5:05:27

. replace `new'=3 if `old'>=31 & `old'<=35
(23,407 real changes made)
r; t=0.06 5:05:27

. replace `new'=4 if `old'>=36 & `old'<=40
(25,353 real changes made)
r; t=0.06 5:05:27

. replace `new'=5 if `old'>=41 & `old'<=45
(23,955 real changes made)
r; t=0.06 5:05:27

. replace `new'=6 if `old'>=46 & `old'<=50
(29,704 real changes made)
r; t=0.06 5:05:27

. replace `new'=7 if `old'>=51 & `old'<=55
(34,196 real changes made)
r; t=0.07 5:05:27

. replace `new'=8 if `old'>=56 & `old'<=60
(40,804 real changes made)
r; t=0.07 5:05:27

. replace `new'=9 if `old'>=61 & `old'<=65
(45,629 real changes made)
r; t=0.06 5:05:27

. replace `new'=10 if `old'>=66 & `old'<=70
(46,876 real changes made)
r; t=0.07 5:05:28

. replace `new'=11 if `old'>=71 & `old'<=75
(38,894 real changes made)
r; t=0.07 5:05:28

. replace `new'=12 if `old'>=76 & `old'<=80
(58,646 real changes made)
r; t=0.07 5:05:28

. label var `new' "Age Group"
r; t=0.00 5:05:28

. label define `new' 0"18-20" 1"21-25" 2"26-30" 3"31-35" 4"36-40" 5"41-45" 6"46-
> 50" 7"51-55" 8"56-60" 9"61-65" 10"66-70" 11"71-75" 12"76-80"
r; t=0.00 5:05:28

. numlabel `new', mask(#_) add
r; t=2.01 5:05:30

. label value `new' `new'
r; t=0.00 5:05:30

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:30

. 
. 
. local new "agegroup_sim"
r; t=0.00 5:05:30

. local old "agegroup"
r; t=0.00 5:05:30

. gen `new'=0 if `old'>=0 & `old'<=4
(318,704 missing values generated)
r; t=0.08 5:05:30

. replace `new'=1 if `old'>=5 & `old'<=9
(174,288 real changes made)
r; t=0.08 5:05:30

. replace `new'=2 if `old'>=10 & `old'<=12
(144,416 real changes made)
r; t=0.07 5:05:30

. label var `new' "Age Group"
r; t=0.00 5:05:30

. label define `new' 0"18-40" 1"41-65" 2"66-80"
r; t=0.00 5:05:30

. numlabel `new', mask(#_) add
r; t=3.04 5:05:33

. label value `new' `new'
r; t=0.01 5:05:33

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:33

. 
. 
. local new "educ"
r; t=0.00 5:05:33

. local old "educa"
r; t=0.00 5:05:33

. gen `new'=0 if `old'>=1 & `old'<=3
(388,203 missing values generated)
r; t=0.12 5:05:33

. replace `new'=1 if `old'==4
(111,890 real changes made)
r; t=0.09 5:05:33

. replace `new'=2 if `old'==5
(116,591 real changes made)
r; t=0.10 5:05:33

. replace `new'=3 if `old'==6
(157,887 real changes made)
r; t=0.10 5:05:33

. label var `new' "Education"
r; t=0.00 5:05:33

. label define `new' 0"BelowHighSch" 1"HighSch" 2"SomeCollege" 3"CollegeorAbove"
r; t=0.00 5:05:33

. numlabel `new', mask(#) add
r; t=3.52 5:05:37

. label value `new' `new'
r; t=0.01 5:05:37

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:37

. 
. 
. local new "edu"
r; t=0.00 5:05:37

. local old "educa"
r; t=0.00 5:05:37

. gen `new'=0 if `old'>=1 & `old'<=4
(276,313 missing values generated)
r; t=0.15 5:05:37

. replace `new'=1 if `old'==5
(116,591 real changes made)
r; t=0.11 5:05:37

. replace `new'=2 if `old'==6
(157,887 real changes made)
r; t=0.12 5:05:37

. label var `new' "Education"
r; t=0.00 5:05:37

. label define `new' 0"HighSchorBelow" 1"SomeCollege" 2"CollegeorAbove"
r; t=0.00 5:05:37

. numlabel `new', mask(#) add
r; t=2.84 5:05:40

. label value `new' `new'
r; t=0.01 5:05:40

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:40

. 
. 
. local new "employstatus_full"
r; t=0.00 5:05:40

. local old "employ1"
r; t=0.00 5:05:40

. gen `new'=0 if `old'>=1 & `old'<=2
(212,638 missing values generated)
r; t=0.11 5:05:40

. replace `new'=1 if `old'>=3 & `old'<=4
(15,984 real changes made)
r; t=0.08 5:05:40

. replace `new'=2 if `old'==5
(20,541 real changes made)
r; t=0.06 5:05:40

. replace `new'=3 if `old'==6
(10,845 real changes made)
r; t=0.06 5:05:40

. replace `new'=4 if `old'==7
(128,809 real changes made)
r; t=0.07 5:05:41

. replace `new'=5 if `old'==8
(29,952 real changes made)
r; t=0.07 5:05:41

. label var `new' "Employment Status"
r; t=0.00 5:05:41

. label define `new' 0"Employed" 1"Unemployed" 2"Homemaker" 3"Student" 4"Retired
> " 5"UnabletoWork"
r; t=0.00 5:05:41

. numlabel `new', mask(#) add
r; t=2.36 5:05:43

. label value `new' `new'
r; t=0.01 5:05:43

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:43

. 
. 
. 
. local new "employstatus"
r; t=0.00 5:05:43

. local old "employ1"
r; t=0.00 5:05:43

. gen `new'=0 if `old'>=1 & `old'<=2
(212,638 missing values generated)
r; t=0.11 5:05:43

. replace `new'=1 if `old'>=3 & `old'<=4
(15,984 real changes made)
r; t=0.07 5:05:43

. replace `new'=2 if `old'>=5 & `old'<=8
(190,147 real changes made)
r; t=0.08 5:05:43

. label var `new' "Employment Status"
r; t=0.00 5:05:43

. label define `new' 0"Employed" 1"Unemployed" 2"Other"
r; t=0.00 5:05:43

. numlabel `new', mask(#) add
r; t=2.23 5:05:45

. label value `new' `new'
r; t=0.01 5:05:45

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:45

. 
. 
. local new "male"
r; t=0.00 5:05:45

. local old "sexvar"
r; t=0.00 5:05:45

. gen `new'=0 if `old'==2
(189,849 missing values generated)
r; t=0.10 5:05:46

. replace `new'=1 if `old'==1
(189,849 real changes made)
r; t=0.08 5:05:46

. label var `new' "Sex"
r; t=0.00 5:05:46

. label define `new' 0"Female" 1"Male"
r; t=0.00 5:05:46

. numlabel `new', mask(#) add
r; t=1.91 5:05:48

. label value `new' `new'
r; t=0.02 5:05:48

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:48

. 
. 
. local new "hispanic"
r; t=0.00 5:05:48

. local old "_hispanc"
r; t=0.00 5:05:48

. gen `new'=2-`old' if `old'<9
(4,958 missing values generated)
r; t=0.12 5:05:48

. label var `new' "Hispanic"
r; t=0.00 5:05:48

. label define `new' 0"Non-Hispanic" 1"Hispanic"
r; t=0.00 5:05:48

. numlabel `new', mask(#) add
r; t=1.81 5:05:49

. label value `new' `new'
r; t=0.01 5:05:50

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:50

. 
. 
. local new "prace"
r; t=0.00 5:05:50

. local old "_prace1"
r; t=0.00 5:05:50

. gen `new'=0 if `old'==1
(82,392 missing values generated)
r; t=0.10 5:05:50

. replace `new'=1 if `old'==2
(34,392 real changes made)
r; t=0.05 5:05:50

. replace `new'=2 if `old'==3
(8,914 real changes made)
r; t=0.06 5:05:50

. replace `new'=3 if `old'==4
(10,251 real changes made)
r; t=0.06 5:05:50

. replace `new'=4 if `old'==5
(3,670 real changes made)
r; t=0.04 5:05:50

. replace `new'=5 if `old'>=6 & `old'<=8
(14,502 real changes made)
r; t=0.06 5:05:50

. label var `new' "Preferred Racial Group"
r; t=0.00 5:05:50

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other"
r; t=0.00 5:05:50

. numlabel `new', mask(#) add
r; t=1.88 5:05:52

. label value `new' `new'
r; t=0.01 5:05:52

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:52

. 
. 
. local new "praceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 5:05:52

. local old1 "prace"
r; t=0.00 5:05:52

. local old2 "hispanic"
r; t=0.00 5:05:52

. gen `new'=0 if `old1'==0 & `old2'==0
(103,853 missing values generated)
r; t=0.09 5:05:52

. replace `new'=1 if `old1'==1 & `old2'==0
(32,519 real changes made)
r; t=0.06 5:05:52

. replace `new'=2 if `old1'==1 & `old2'==1
(1,620 real changes made)
r; t=0.06 5:05:52

. replace `new'=3 if `old1'==0 & `old2'==1
(19,854 real changes made)
r; t=0.06 5:05:52

. replace `new'=4 if `old1'==2
(8,914 real changes made)
r; t=0.05 5:05:52

. replace `new'=5 if `old1'==3
(10,251 real changes made)
r; t=0.05 5:05:52

. replace `new'=6 if `old1'==4 & `old2'==0
(3,130 real changes made)
r; t=0.06 5:05:52

. replace `new'=7 if `old1'==4 & `old2'==1
(490 real changes made)
r; t=0.06 5:05:52

. replace `new'=8 if `old1'==5
(14,502 real changes made)
r; t=0.06 5:05:52

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:05:52

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 5:05:52

. numlabel `new', mask(#) add
r; t=1.78 5:05:54

. label value `new' `new'
r; t=0.00 5:05:54

. note `new': Original: `old' | `tag'
r; t=0.00 5:05:54

. 
. 
. local new "praceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 5:05:54

. local vold "praceethnicgpf"
r; t=0.00 5:05:54

. gen `new'=0 if `vold'==0
(103,853 missing values generated)
r; t=0.09 5:05:54

. replace `new'=1 if `vold'==1
(32,519 real changes made)
r; t=0.05 5:05:54

. replace `new'=2 if `vold'==2
(1,620 real changes made)
r; t=0.05 5:05:54

. replace `new'=3 if `vold'==3
(19,854 real changes made)
r; t=0.06 5:05:54

. replace `new'=4 if `vold'==6
(3,130 real changes made)
r; t=0.06 5:05:54

. replace `new'=5 if `vold'==7
(490 real changes made)
r; t=0.05 5:05:54

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(33,667 real changes made)
r; t=0.07 5:05:55

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:05:55

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 5:05:55

. numlabel `new', mask(#) add
r; t=1.98 5:05:57

. label value `new' `new'
r; t=0.01 5:05:57

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:05:57

. 
. 
. local new "praceethnicgp_sim" //Note that I force those who responded to race 
> question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 5:05:57

. local vold1 "praceethnicgpf"
r; t=0.00 5:05:57

. local vold2 "prace"
r; t=0.00 5:05:57

. gen `new'=0 if `vold1'==0
(103,853 missing values generated)
r; t=0.09 5:05:57

. replace `new'=1 if `vold1'==1 | `vold1'==2 | `vold2'==1
(34,392 real changes made)
r; t=0.07 5:05:57

. replace `new'=2 if `vold1'==3
(19,854 real changes made)
r; t=0.07 5:05:57

. replace `new'=3 if `vold1'==6 | `vold1'==7 | `vold2'==4
(3,670 real changes made)
r; t=0.07 5:05:57

. replace `new'=4 if `vold1'==4 | `vold1'==5 | `vold1'==8 | `vold2'==2 | `vold2'
> ==3 | `vold2'==5
(33,667 real changes made)
r; t=0.10 5:05:57

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:05:57

. label define `new' 0"WhiteNon-Hispanic" 1"Black" 2"HispanicWhite" 3"NHPI" 4"Ot
> her"
r; t=0.00 5:05:57

. numlabel `new', mask(#) add
r; t=2.57 5:05:59

. label value `new' `new'
r; t=0.01 5:05:59

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:05:59

. 
. 
. 
. 
. local new "mrace"
r; t=0.00 5:05:59

. local old "_mrace1"
r; t=0.00 5:05:59

. gen `new'=0 if `old'==1
(86,381 missing values generated)
r; t=0.13 5:06:00

. replace `new'=1 if `old'==2
(33,202 real changes made)
r; t=0.08 5:06:00

. replace `new'=2 if `old'==3
(7,992 real changes made)
r; t=0.07 5:06:00

. replace `new'=3 if `old'==4
(9,528 real changes made)
r; t=0.07 5:06:00

. replace `new'=4 if `old'==5
(2,834 real changes made)
r; t=0.06 5:06:00

. replace `new'=5 if `old'==6
(12,682 real changes made)
r; t=0.07 5:06:00

. replace `new'=6 if `old'==7
(9,480 real changes made)
r; t=0.07 5:06:00

. label var `new' "Multiracial Racial Categorization"
r; t=0.00 5:06:00

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other" 6"Multiracial"
r; t=0.00 5:06:00

. numlabel `new', mask(#) add
r; t=2.56 5:06:03

. label value `new' `new'
r; t=0.00 5:06:03

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:03

. 
. 
. local new "mraceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 5:06:03

. local old1 "mrace"
r; t=0.00 5:06:03

. local old2 "hispanic"
r; t=0.00 5:06:03

. gen `new'=0 if `old1'==0 & `old2'==0
(107,518 missing values generated)
r; t=0.11 5:06:03

. replace `new'=1 if `old1'==1 & `old2'==0
(31,423 real changes made)
r; t=0.08 5:06:03

. replace `new'=2 if `old1'==1 & `old2'==1
(1,538 real changes made)
r; t=0.08 5:06:03

. replace `new'=3 if `old1'==0 & `old2'==1
(19,569 real changes made)
r; t=0.07 5:06:03

. replace `new'=4 if `old1'==2
(7,992 real changes made)
r; t=0.06 5:06:03

. replace `new'=5 if `old1'==3
(9,528 real changes made)
r; t=0.07 5:06:03

. replace `new'=6 if `old1'==4 & `old2'==0
(2,379 real changes made)
r; t=0.08 5:06:03

. replace `new'=7 if `old1'==4 & `old2'==1
(418 real changes made)
r; t=0.08 5:06:03

. replace `new'=8 if `old1'==5
(12,682 real changes made)
r; t=0.08 5:06:03

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:03

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 5:06:03

. numlabel `new', mask(#) add
r; t=2.25 5:06:06

. label value `new' `new'
r; t=0.01 5:06:06

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:06

. 
. 
. local new "mraceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 5:06:06

. local vold "mraceethnicgpf"
r; t=0.00 5:06:06

. gen `new'=0 if `vold'==0
(107,518 missing values generated)
r; t=0.09 5:06:06

. replace `new'=1 if `vold'==1
(31,423 real changes made)
r; t=0.06 5:06:06

. replace `new'=2 if `vold'==2
(1,538 real changes made)
r; t=0.05 5:06:06

. replace `new'=3 if `vold'==3
(19,569 real changes made)
r; t=0.05 5:06:06

. replace `new'=4 if `vold'==6
(2,379 real changes made)
r; t=0.05 5:06:06

. replace `new'=5 if `vold'==7
(418 real changes made)
r; t=0.06 5:06:06

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(30,202 real changes made)
r; t=0.06 5:06:06

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:06

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 5:06:06

. numlabel `new', mask(#) add
r; t=1.81 5:06:08

. label value `new' `new'
r; t=0.01 5:06:08

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:06:08

. 
. 
. local new "multiracial_mark"
r; t=0.00 5:06:08

. local old1 "_prace1"
r; t=0.00 5:06:08

. local old2 "_mrace1"
r; t=0.00 5:06:08

. gen `new'=0 if `old1'==`old2' & `old1'<77
(18,767 missing values generated)
r; t=0.12 5:06:08

. replace `new'=1 if `old1'!=`old2' & `old1'<77
(8,104 real changes made)
r; t=0.07 5:06:08

. label var `new' "Multiracial Marker"
r; t=0.00 5:06:08

. label define `new' 0"SingleRaceOrNoPreferred" 1"PreferredRaceandMultiracial"
r; t=0.00 5:06:08

. numlabel `new', mask(#) add
r; t=1.89 5:06:10

. label value `new' `new'
r; t=0.01 5:06:10

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:10

. 
. 
. local new "praceethnicgp_multi" //Note that I force those who responded to rac
> e question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 5:06:10

. local vold1 "praceethnicgp_sim"
r; t=0.00 5:06:10

. local vold2 "multiracial_mark"
r; t=0.00 5:06:10

. gen `new'=0 if `vold1'==0 & `vold2'==0
(107,518 missing values generated)
r; t=0.10 5:06:10

. replace `new'=1 if `vold1'==0 & `vold2'==1
(3,665 real changes made)
r; t=0.07 5:06:10

. replace `new'=2 if `vold1'==1 & `vold2'==0
(33,202 real changes made)
r; t=0.07 5:06:10

. replace `new'=3 if `vold1'==1 & `vold2'==1
(1,190 real changes made)
r; t=0.07 5:06:10

. replace `new'=4 if `vold1'==2 & `vold2'==0
(19,569 real changes made)
r; t=0.06 5:06:10

. replace `new'=5 if `vold1'==2 & `vold2'==1
(285 real changes made)
r; t=0.06 5:06:10

. replace `new'=6 if `vold1'==3 & `vold2'==0
(2,834 real changes made)
r; t=0.08 5:06:10

. replace `new'=7 if `vold1'==3 & `vold2'==1
(836 real changes made)
r; t=0.07 5:06:10

. replace `new'=8 if `vold1'==4 & `vold2'==0
(31,578 real changes made)
r; t=0.07 5:06:11

. replace `new'=9 if `vold1'==4 & `vold2'==1
(2,089 real changes made)
r; t=0.08 5:06:11

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:11

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" ///
> 4"HWhite_Single" 5"HWhite_Multi" 6"NHPI_Single" 7"NHPI_Multi" 8"Other_Single" 
> 9"Other_Multi"
r; t=0.00 5:06:11

. numlabel `new', mask(#) add
r; t=1.96 5:06:13

. label value `new' `new'
r; t=0.01 5:06:13

. note `new': Refer to `vold1' `vold2' | `tag'
r; t=0.00 5:06:13

. 
. 
. local new "praceethnicgp_multi_sim" //Note that I force those who responded to
>  race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 5:06:13

. local vold "praceethnicgp_multi"
r; t=0.00 5:06:13

. gen `new'=0 if `vold'==0
(107,518 missing values generated)
r; t=0.10 5:06:13

. replace `new'=1 if `vold'==1
(3,665 real changes made)
r; t=0.06 5:06:13

. replace `new'=2 if `vold'==6
(2,834 real changes made)
r; t=0.06 5:06:13

. replace `new'=3 if `vold'==7
(836 real changes made)
r; t=0.06 5:06:13

. replace `new'=4 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(87,913 real changes made)
r; t=0.07 5:06:13

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:13

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI_Single" 3"NHPI_Mu
> lti" 4"Other"
r; t=0.00 5:06:13

. numlabel `new', mask(#) add
r; t=2.27 5:06:15

. label value `new' `new'
r; t=0.00 5:06:15

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:06:15

. 
. 
. local new "praceethnicgp_multi_sim2" //Note that I force those who responded t
> o race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 5:06:15

. local vold "praceethnicgp_multi_sim"
r; t=0.00 5:06:15

. gen `new'=0 if `vold'==0 | `vold'==1
(103,853 missing values generated)
r; t=0.10 5:06:15

. replace `new'=1 if `vold'==2
(2,834 real changes made)
r; t=0.04 5:06:15

. replace `new'=2 if `vold'==3
(836 real changes made)
r; t=0.06 5:06:15

. replace `new'=3 if `vold'==4
(87,913 real changes made)
r; t=0.06 5:06:15

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:15

. label define `new' 0"nHWhite" 1"NHPI_Single" 2"NHPI_Multi" 3"Other"
r; t=0.00 5:06:15

. numlabel `new', mask(#) add
r; t=1.97 5:06:17

. label value `new' `new'
r; t=0.00 5:06:17

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:06:17

. 
. 
. local new "praceethnicgp_multi_altsim" //Note that I force those who responded
>  to race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 5:06:17

. local vold "praceethnicgp_multi"
r; t=0.00 5:06:17

. gen `new'=0 if `vold'==0
(107,518 missing values generated)
r; t=0.09 5:06:18

. replace `new'=1 if `vold'==1
(3,665 real changes made)
r; t=0.05 5:06:18

. replace `new'=2 if `vold'==2
(33,202 real changes made)
r; t=0.05 5:06:18

. replace `new'=3 if `vold'==3
(1,190 real changes made)
r; t=0.05 5:06:18

. replace `new'=4 if `vold'==4 | `vold'==5
(19,854 real changes made)
r; t=0.07 5:06:18

. replace `new'=5 if `vold'==6
(2,834 real changes made)
r; t=0.05 5:06:18

. replace `new'=6 if `vold'==7
(836 real changes made)
r; t=0.05 5:06:18

. replace `new'=7 if `vold'==8
(31,578 real changes made)
r; t=0.05 5:06:18

. replace `new'=8 if `vold'==9
(2,089 real changes made)
r; t=0.06 5:06:18

. label var `new' "Racial/ethnic Group"
r; t=0.00 5:06:18

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" 4"HWhite" 5"NHPI_Single" 6"NHPI_Multi" 7"Other_Single" 8"Other_Multi"
r; t=0.00 5:06:18

. numlabel `new', mask(#) add
r; t=1.92 5:06:20

. label value `new' `new'
r; t=0.01 5:06:20

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:06:20

. 
. 
. local new "praceethnicgp_multi_simplest" //Note that I force those who respond
> ed to race question but not Hispanic question to be either Black, NHPI, or oth
> er
r; t=0.00 5:06:20

. local vold "praceethnicgp_multi"
r; t=0.00 5:06:20

. gen `new'=0 if `vold'==0
(107,518 missing values generated)
r; t=0.09 5:06:20

. replace `new'=1 if `vold'==1
(3,665 real changes made)
r; t=0.06 5:06:20

. replace `new'=2 if `vold'>=6 & `vold'<=7
(3,670 real changes made)
r; t=0.06 5:06:20

. replace `new'=3 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(87,913 real changes made)
r; t=0.08 5:06:20

. label var `new' "Racial/ethnic Group"
r; t=0.02 5:06:20

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI" 3"Other"
r; t=0.00 5:06:20

. numlabel `new', mask(#) add
r; t=2.73 5:06:23

. label value `new' `new'
r; t=0.01 5:06:23

. note `new': Refer to `vold' | `tag'
r; t=0.00 5:06:23

. 
. 
. 
. local new "hhincome"
r; t=0.00 5:06:23

. local old "income2"
r; t=0.00 5:06:23

. gen `new'=0 if `old'==1
(402,408 missing values generated)
r; t=0.12 5:06:23

. replace `new'=1 if `old'==2
(16,122 real changes made)
r; t=0.08 5:06:23

. replace `new'=2 if `old'==3
(23,391 real changes made)
r; t=0.07 5:06:23

. replace `new'=3 if `old'==4
(30,001 real changes made)
r; t=0.08 5:06:23

. replace `new'=4 if `old'==5
(34,496 real changes made)
r; t=0.08 5:06:23

. replace `new'=5 if `old'==6
(46,572 real changes made)
r; t=0.08 5:06:23

. replace `new'=6 if `old'==7
(54,252 real changes made)
r; t=0.08 5:06:24

. replace `new'=7 if `old'==8
(117,793 real changes made)
r; t=0.10 5:06:24

. label var `new' "Household Income"
r; t=0.00 5:06:24

. label define `new' 0"<10000" 1"10000-14999" 2"15000-19999" 3"20000-24999" 4"25
> 000-34999" 5"35000-49999" 6"50000-74999" 7"75000+"
r; t=0.00 5:06:24

. numlabel `new', mask(#_) add
r; t=2.93 5:06:27

. label value `new' `new'
r; t=0.01 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. 
. 
. 
. *Technical variables
. local new "svyweight"
r; t=0.00 5:06:27

. local old "_llcpwt"
r; t=0.00 5:06:27

. gen `new'=`old'
r; t=0.10 5:06:27

. label var `new' "Survey weight"
r; t=0.00 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. local new "strata"
r; t=0.00 5:06:27

. local old "_ststr"
r; t=0.00 5:06:27

. gen `new'=`old'
r; t=0.10 5:06:27

. label var `new' "Strata"
r; t=0.00 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. local new "psu"
r; t=0.00 5:06:27

. local old "_psu"
r; t=0.00 5:06:27

. gen double `new'=`old'
r; t=0.09 5:06:27

. label var `new' "PSU"
r; t=0.00 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. local new "state"
r; t=0.00 5:06:27

. local old "_state"
r; t=0.00 5:06:27

. gen `new'=`old'
r; t=0.08 5:06:27

. label var `new' "State FIPS Code"
r; t=0.00 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. local new "month"
r; t=0.00 5:06:27

. local old "imonth"
r; t=0.00 5:06:27

. gen `new'=`old'
r; t=0.30 5:06:27

. label var `new' "Interview Month"
r; t=0.00 5:06:27

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:27

. 
. 
. local new "year"
r; t=0.00 5:06:27

. local old "iyear"
r; t=0.00 5:06:27

. gen `new'=`old'
r; t=0.32 5:06:28

. label var `new' "Interview Year"
r; t=0.00 5:06:28

. note `new': Original: `old' | `tag'
r; t=0.01 5:06:28

. 
. 
. local new "interview_comp"
r; t=0.00 5:06:28

. local old "dispcode"
r; t=0.00 5:06:28

. gen `new'=0 if `old'==1200
(345,315 missing values generated)
r; t=0.09 5:06:28

. replace `new'=1 if `old'==1100
(345,315 real changes made)
r; t=0.08 5:06:28

. label var `new' "Interview Complete"
r; t=0.00 5:06:28

. label define `new' 0"PartialInterview" 1"CompletedInterview"
r; t=0.00 5:06:28

. numlabel `new', mask(#) add
r; t=2.76 5:06:31

. label value `new' `new'
r; t=0.01 5:06:31

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:31

. 
. 
. local new "metrogroup"
r; t=0.00 5:06:31

. local old "mscode"
r; t=0.00 5:06:31

. gen `new'=0 if `old'==1
(376,077 missing values generated)
r; t=0.09 5:06:31

. replace `new'=1 if `old'==2
(26,775 real changes made)
r; t=0.06 5:06:31

. replace `new'=2 if `old'==3
(25,254 real changes made)
r; t=0.06 5:06:31

. replace `new'=3 if `old'==5
(51,800 real changes made)
r; t=0.06 5:06:31

. replace `new'=4 if `old'==.
(272,248 real changes made)
r; t=0.08 5:06:31

. label var `new' "Metropolitan Status Code"
r; t=0.00 5:06:31

. label define `new' 0"CenterCityinMSA" 1"OutsideCityInCounty" 2"SuburbanCounty"
>  3"OutsideMSA" 4"GU/PR/VI/Cell"
r; t=0.00 5:06:31

. numlabel `new', mask(#) add
r; t=2.02 5:06:33

. label value `new' `new'
r; t=0.01 5:06:33

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:33

. 
. 
. 
. local new "censusdivision"
r; t=0.00 5:06:33

. local old "state"
r; t=0.00 5:06:33

. gen `new'=0 if `old'==9 | `old'==23 | `old'==25 | `old'==33 | `old'==44 | `old
> '==50
(371,578 missing values generated)
r; t=0.08 5:06:33

. replace `new'=1 if `old'==34 | `old'==36 | `old'==42
(20,838 real changes made)
r; t=0.06 5:06:33

. replace `new'=2 if `old'==17 | `old'==18 | `old'==26 | `old'==39 | `old'==55
(43,411 real changes made)
r; t=0.08 5:06:33

. replace `new'=3 if `old'==19 | `old'==20 | `old'==27 | `old'==29 | `old'==31 |
>  `old'==38 | `old'==46
(72,047 real changes made)
r; t=0.09 5:06:33

. replace `new'=4 if `old'==12 | `old'==13 | `old'==37 | `old'==45 | `old'==51 |
>  `old'==11 | `old'==24 | `old'==10 | `old'==54
(74,939 real changes made)
r; t=0.10 5:06:33

. replace `new'=5 if `old'==1  | `old'==21 | `old'==28 | `old'==47
(26,394 real changes made)
r; t=0.07 5:06:33

. replace `new'=6 if `old'==5 | `old'==22 | `old'==40 | `old'==48
(28,709 real changes made)
r; t=0.07 5:06:33

. replace `new'=7 if `old'==4 | `old'==8 | `old'==16 | `old'==30 | `old'==32 | `
> old'==35 | `old'==49 | `old'==56
(55,403 real changes made)
r; t=0.09 5:06:34

. replace `new'=8 if `old'==2 | `old'==6 | `old'==15 | `old'==41 | `old'==53
(41,379 real changes made)
r; t=0.09 5:06:34

. replace `new'=9 if `old'==66
(2,426 real changes made)
r; t=0.06 5:06:34

. replace `new'=10 if `old'==72
(6,032 real changes made)
r; t=0.07 5:06:34

. label var `new' "Census Division"
r; t=0.00 5:06:34

. label define `new' 0"NewEngland" 1"MidAtlantic" 2"ENCentral" 3"WNCentral" 4"SA
> tlantic" 5"ESCentral" 6"WSCentral" 7"Mountain" 8"Pacific" 9"Guam" 10"PuertoRic
> o"
r; t=0.00 5:06:34

. numlabel `new', mask(#) add
r; t=2.18 5:06:36

. label value `new' `new'
r; t=0.01 5:06:36

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:36

. 
. 
. local new "censusregion"
r; t=0.00 5:06:36

. local old "censusdivision"
r; t=0.00 5:06:36

. gen `new'=0 if `old'>=0 & `old'<=1
(350,740 missing values generated)
r; t=0.07 5:06:36

. replace `new'=1 if `old'>=2 & `old'<=3
(115,458 real changes made)
r; t=0.06 5:06:36

. replace `new'=2 if `old'>=4 & `old'<=6
(130,042 real changes made)
r; t=0.06 5:06:36

. replace `new'=3 if `old'>=7 & `old'<=8
(96,782 real changes made)
r; t=0.06 5:06:36

. replace `new'=4 if `old'==9
(2,426 real changes made)
r; t=0.05 5:06:36

. replace `new'=5 if `old'==10
(6,032 real changes made)
r; t=0.05 5:06:36

. label var `new' "Census Region"
r; t=0.00 5:06:36

. label define `new' 0"Northeast" 1"MidWest" 2"South" 3"West" 4"Guam" 5"PuertoRi
> co"
r; t=0.00 5:06:36

. numlabel `new', mask(#) add
r; t=1.85 5:06:38

. label value `new' `new'
r; t=0.01 5:06:38

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:38

. 
. 
. local new "censusregion_sim"
r; t=0.00 5:06:38

. local old "censusregion"
r; t=0.00 5:06:38

. gen `new'=0 if `old'>=0 & `old'<=2
(105,240 missing values generated)
r; t=0.09 5:06:38

. replace `new'=1 if `old'==3 & state!=15
(89,098 real changes made)
r; t=0.06 5:06:38

. replace `new'=2 if state==15 //Put Hawaii into a separate category
(7,684 real changes made)
r; t=0.05 5:06:38

. replace `new'=3 if `old'==4
(2,426 real changes made)
r; t=0.05 5:06:38

. replace `new'=4 if `old'==5
(6,032 real changes made)
r; t=0.05 5:06:39

. label var `new' "Census Region"
r; t=0.00 5:06:39

. label define `new' 0"Eastern" 1"West" 2"Hawaii" 3"Guam" 4"PuertoRico"
r; t=0.00 5:06:39

. numlabel `new', mask(#) add
r; t=1.85 5:06:40

. label value `new' `new'
r; t=0.01 5:06:40

. note `new': Original: `old' | `tag'
r; t=0.00 5:06:40

. 
. 
. 
. 
. 
. *For gsem estimation
. gen exe_intensity_sim_m=exe_intensity_sim if male==1
(241,487 missing values generated)
r; t=0.08 5:06:40

. gen exe_intensity_sim_f=exe_intensity_sim if male==0
(204,989 missing values generated)
r; t=0.09 5:06:41

. 
. gen exe_intensity_simplest_m=exe_intensity_simplest if male==1
(241,487 missing values generated)
r; t=0.09 5:06:41

. gen exe_intensity_simplest_f=exe_intensity_simplest if male==0
(204,989 missing values generated)
r; t=0.09 5:06:41

. 
. gen exe_aerobic_advice_m=exe_aerobic_advice if male==1
(251,721 missing values generated)
r; t=0.08 5:06:41

. gen exe_aerobic_advice_f=exe_aerobic_advice if male==0
(217,148 missing values generated)
r; t=0.09 5:06:41

. 
. gen exe_strength_advice_m=exe_strength_advice if male==1
(245,114 missing values generated)
r; t=0.09 5:06:41

. gen exe_strength_advice_f=exe_strength_advice if male==0
(210,236 missing values generated)
r; t=0.09 5:06:41

. 
. gen exe_active_m=exe_active if male==1
(250,313 missing values generated)
r; t=0.08 5:06:41

. gen exe_active_f=exe_active if male==0
(217,090 missing values generated)
r; t=0.10 5:06:41

. 
. 
. local dvlist exe_intensity_sim_m exe_intensity_sim_f exe_aerobic_advice_m exe_
> aerobic_advice_f
r; t=0.00 5:06:41

. local dvlist `dvlist' exe_strength_advice_m exe_strength_advice_f exe_active_m
>  exe_active_f exe_intensity_simplest_m exe_intensity_simplest_f
r; t=0.00 5:06:41

. foreach var in `dvlist' {
  2.         forvalues dvnum=1(1)20 {
  3.                 gen `var'`dvnum'=`var'
  4.         }
  5. }
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(251,721 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(217,148 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(245,114 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(210,236 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(250,313 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(217,090 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(241,487 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
(204,989 missing values generated)
r; t=13.92 5:06:55

. 
. /*
> *Generate census region-specific DV
> foreach var in `dvlist' {
>         local `var'_
>         forvalues dvnum=1(1)20 {
>                 gen `var'`dvnum'=`var'
>         }
> }
> */
. 
. *Generate outcomes by census region
. gen exe_intensity_sim_m_cr0=exe_intensity_sim_m if censusregion_sim==0
(287,964 missing values generated)
r; t=0.08 5:06:55

. gen exe_intensity_sim_m_cr1=exe_intensity_sim_m if censusregion_sim==1
(378,550 missing values generated)
r; t=0.05 5:06:55

. gen exe_intensity_sim_m_cr2=exe_intensity_sim_m if censusregion_sim==2
(414,774 missing values generated)
r; t=0.04 5:06:55

. gen exe_intensity_sim_m_cr3=exe_intensity_sim_m if censusregion_sim==3
(417,194 missing values generated)
r; t=0.02 5:06:55

. gen exe_intensity_sim_m_cr4=exe_intensity_sim_m if censusregion_sim==4
(416,077 missing values generated)
r; t=0.04 5:06:55

. 
. gen exe_intensity_sim_f_cr0=exe_intensity_sim_f if censusregion_sim==0
(257,073 missing values generated)
r; t=0.05 5:06:55

. gen exe_intensity_sim_f_cr1=exe_intensity_sim_f if censusregion_sim==1
(374,859 missing values generated)
r; t=0.05 5:06:56

. gen exe_intensity_sim_f_cr2=exe_intensity_sim_f if censusregion_sim==2
(414,500 missing values generated)
r; t=0.05 5:06:56

. gen exe_intensity_sim_f_cr3=exe_intensity_sim_f if censusregion_sim==3
(417,060 missing values generated)
r; t=0.05 5:06:56

. gen exe_intensity_sim_f_cr4=exe_intensity_sim_f if censusregion_sim==4
(414,569 missing values generated)
r; t=0.02 5:06:56

. 
. 
. gen exe_intensity_simplest_m_cr0=exe_intensity_simplest_m if censusregion_sim=
> =0
(287,964 missing values generated)
r; t=0.94 5:06:57

. gen exe_intensity_simplest_m_cr1=exe_intensity_simplest_m if censusregion_sim=
> =1
(378,550 missing values generated)
r; t=0.11 5:06:57

. gen exe_intensity_simplest_m_cr2=exe_intensity_simplest_m if censusregion_sim=
> =2
(414,774 missing values generated)
r; t=0.11 5:06:57

. gen exe_intensity_simplest_m_cr3=exe_intensity_simplest_m if censusregion_sim=
> =3
(417,194 missing values generated)
r; t=0.09 5:06:57

. gen exe_intensity_simplest_m_cr4=exe_intensity_simplest_m if censusregion_sim=
> =4
(416,077 missing values generated)
r; t=0.10 5:06:57

. 
. gen exe_intensity_simplest_f_cr0=exe_intensity_simplest_f if censusregion_sim=
> =0
(257,073 missing values generated)
r; t=0.11 5:06:57

. gen exe_intensity_simplest_f_cr1=exe_intensity_simplest_f if censusregion_sim=
> =1
(374,859 missing values generated)
r; t=0.09 5:06:57

. gen exe_intensity_simplest_f_cr2=exe_intensity_simplest_f if censusregion_sim=
> =2
(414,500 missing values generated)
r; t=0.08 5:06:57

. gen exe_intensity_simplest_f_cr3=exe_intensity_simplest_f if censusregion_sim=
> =3
(417,060 missing values generated)
r; t=0.08 5:06:57

. gen exe_intensity_simplest_f_cr4=exe_intensity_simplest_f if censusregion_sim=
> =4
(414,569 missing values generated)
r; t=0.08 5:06:57

. 
. 
. 
. 
. 
. gen exe_aerobic_advice_m_cr0=exe_aerobic_advice_m if censusregion_sim==0
(296,036 missing values generated)
r; t=0.12 5:06:58

. gen exe_aerobic_advice_m_cr1=exe_aerobic_advice_m if censusregion_sim==1
(380,448 missing values generated)
r; t=0.10 5:06:58

. gen exe_aerobic_advice_m_cr2=exe_aerobic_advice_m if censusregion_sim==2
(414,911 missing values generated)
r; t=0.09 5:06:58

. gen exe_aerobic_advice_m_cr3=exe_aerobic_advice_m if censusregion_sim==3
(417,253 missing values generated)
r; t=0.09 5:06:58

. gen exe_aerobic_advice_m_cr4=exe_aerobic_advice_m if censusregion_sim==4
(416,145 missing values generated)
r; t=0.09 5:06:58

. 
. gen exe_aerobic_advice_f_cr0=exe_aerobic_advice_f if censusregion_sim==0
(267,068 missing values generated)
r; t=0.12 5:06:58

. gen exe_aerobic_advice_f_cr1=exe_aerobic_advice_f if censusregion_sim==1
(376,786 missing values generated)
r; t=0.10 5:06:58

. gen exe_aerobic_advice_f_cr2=exe_aerobic_advice_f if censusregion_sim==2
(414,606 missing values generated)
r; t=0.10 5:06:58

. gen exe_aerobic_advice_f_cr3=exe_aerobic_advice_f if censusregion_sim==3
(417,106 missing values generated)
r; t=0.10 5:06:58

. gen exe_aerobic_advice_f_cr4=exe_aerobic_advice_f if censusregion_sim==4
(414,654 missing values generated)
r; t=0.10 5:06:58

. 
. gen exe_strength_advice_m_cr0=exe_strength_advice_m if censusregion_sim==0
(290,860 missing values generated)
r; t=0.12 5:06:59

. gen exe_strength_advice_m_cr1=exe_strength_advice_m if censusregion_sim==1
(379,249 missing values generated)
r; t=0.10 5:06:59

. gen exe_strength_advice_m_cr2=exe_strength_advice_m if censusregion_sim==2
(414,804 missing values generated)
r; t=0.08 5:06:59

. gen exe_strength_advice_m_cr3=exe_strength_advice_m if censusregion_sim==3
(417,208 missing values generated)
r; t=0.09 5:06:59

. gen exe_strength_advice_m_cr4=exe_strength_advice_m if censusregion_sim==4
(416,065 missing values generated)
r; t=0.09 5:06:59

. 
. gen exe_strength_advice_f_cr0=exe_strength_advice_f if censusregion_sim==0
(261,300 missing values generated)
r; t=0.12 5:06:59

. gen exe_strength_advice_f_cr1=exe_strength_advice_f if censusregion_sim==1
(375,814 missing values generated)
r; t=0.12 5:06:59

. gen exe_strength_advice_f_cr2=exe_strength_advice_f if censusregion_sim==2
(414,543 missing values generated)
r; t=0.09 5:06:59

. gen exe_strength_advice_f_cr3=exe_strength_advice_f if censusregion_sim==3
(417,084 missing values generated)
r; t=0.10 5:06:59

. gen exe_strength_advice_f_cr4=exe_strength_advice_f if censusregion_sim==4
(414,567 missing values generated)
r; t=0.09 5:06:59

. 
. 
. gen exe_active_m_cr0=exe_active_m if censusregion_sim==0
(295,025 missing values generated)
r; t=0.13 5:07:00

. gen exe_active_m_cr1=exe_active_m if censusregion_sim==1
(380,121 missing values generated)
r; t=0.11 5:07:00

. gen exe_active_m_cr2=exe_active_m if censusregion_sim==2
(414,876 missing values generated)
r; t=0.10 5:07:00

. gen exe_active_m_cr3=exe_active_m if censusregion_sim==3
(417,244 missing values generated)
r; t=0.10 5:07:00

. gen exe_active_m_cr4=exe_active_m if censusregion_sim==4
(416,119 missing values generated)
r; t=0.10 5:07:00

. 
. gen exe_active_f_cr0=exe_active_f if censusregion_sim==0
(267,022 missing values generated)
r; t=0.12 5:07:00

. gen exe_active_f_cr1=exe_active_f if censusregion_sim==1
(376,812 missing values generated)
r; t=0.10 5:07:00

. gen exe_active_f_cr2=exe_active_f if censusregion_sim==2
(414,583 missing values generated)
r; t=0.08 5:07:00

. gen exe_active_f_cr3=exe_active_f if censusregion_sim==3
(417,119 missing values generated)
r; t=0.09 5:07:00

. gen exe_active_f_cr4=exe_active_f if censusregion_sim==4
(414,626 missing values generated)
r; t=0.08 5:07:00

. 
. 
. 
. svyset [pweight=svyweight], strata(strata) psu(psu) singleunit(centered)

      pweight: svyweight
          VCE: linearized
  Single unit: centered
     Strata 1: strata
         SU 1: psu
        FPC 1: <zero>
r; t=0.01 5:07:00

. 
. 
. 
. drop if mi(male) //don't want to impute missing values of gender
(0 observations deleted)
r; t=0.13 5:07:01

. 
. gen id=_n //generate unique respondent's ID
r; t=0.05 5:07:01

. 
. 
. compress
  variable srh was float now byte
  variable badphyhlth was float now byte
  variable badmenhlth was float now byte
  variable actpoorhlth was float now byte
  variable asthmadiag was float now byte
  variable cholesteroldiag was float now byte
  variable heartattackdiag was float now byte
  variable heartdiseasediag was float now byte
  variable strokediag was float now byte
  variable diabetesdiag was float now byte
  variable highbloodpressurediag was float now byte
  variable actlim was float now byte
  variable walkdiff was float now byte
  variable dressdiff was float now byte
  variable erranddiffalone was float now byte
  variable funclimit was float now byte
  variable bodycheck was float now byte
  variable bingedrink was float now byte
  variable heavydrink was float now byte
  variable smokeever was float now byte
  variable smoking was float now byte
  variable smokingsim was float now byte
  variable veg1perday was float now byte
  variable greenveg1perday was float now byte
  variable fries1perday was float now byte
  variable potato1perday was float now byte
  variable otherveg1perday was float now byte
  variable totalfruit1perday was float now byte
  variable fruitjuice1perday was float now byte
  variable fruit1perday was float now byte
  variable bmicat was float now byte
  variable hivrisk was float now byte
  variable exercise was float now byte
  variable exercise1type was float now byte
  variable exercise1min was float now int
  variable exercise2type was float now byte
  variable exercise2min was float now int
  variable exe1_intensity was float now byte
  variable exe2_intensity was float now byte
  variable exe_intensity was float now byte
  variable exe_intensity_sim was float now byte
  variable exe_intensity_simplest was float now byte
  variable exe1_min_per_week was float now int
  variable exe2_min_per_week was float now int
  variable exe_active was float now byte
  variable exe_aerobic_advice was float now byte
  variable exe_strength_advice was float now byte
  variable exe_aero_strength_advice was float now byte
  variable metval1 was float now int
  variable metval2 was float now int
  variable metval_avg was float now int
  variable afforddoc was float now byte
  variable hlthcare was float now byte
  variable hlthcare1864 was float now byte
  variable yearsold was float now byte
  variable agegroup was float now byte
  variable agegroup_sim was float now byte
  variable educ was float now byte
  variable edu was float now byte
  variable employstatus_full was float now byte
  variable employstatus was float now byte
  variable male was float now byte
  variable hispanic was float now byte
  variable prace was float now byte
  variable praceethnicgpf was float now byte
  variable praceethnicgp was float now byte
  variable praceethnicgp_sim was float now byte
  variable mrace was float now byte
  variable mraceethnicgpf was float now byte
  variable mraceethnicgp was float now byte
  variable multiracial_mark was float now byte
  variable praceethnicgp_multi was float now byte
  variable praceethnicgp_multi_sim was float now byte
  variable praceethnicgp_multi_sim2 was float now byte
  variable praceethnicgp_multi_altsim was float now byte
  variable praceethnicgp_multi_simplest was float now byte
  variable hhincome was float now byte
  variable state was float now byte
  variable interview_comp was float now byte
  variable metrogroup was float now byte
  variable censusdivision was float now byte
  variable censusregion was float now byte
  variable censusregion_sim was float now byte
  variable exe_intensity_sim_m was float now byte
  variable exe_intensity_sim_f was float now byte
  variable exe_intensity_simplest_m was float now byte
  variable exe_intensity_simplest_f was float now byte
  variable exe_aerobic_advice_m was float now byte
  variable exe_aerobic_advice_f was float now byte
  variable exe_strength_advice_m was float now byte
  variable exe_strength_advice_f was float now byte
  variable exe_active_m was float now byte
  variable exe_active_f was float now byte
  variable exe_intensity_sim_m1 was float now byte
  variable exe_intensity_sim_m2 was float now byte
  variable exe_intensity_sim_m3 was float now byte
  variable exe_intensity_sim_m4 was float now byte
  variable exe_intensity_sim_m5 was float now byte
  variable exe_intensity_sim_m6 was float now byte
  variable exe_intensity_sim_m7 was float now byte
  variable exe_intensity_sim_m8 was float now byte
  variable exe_intensity_sim_m9 was float now byte
  variable exe_intensity_sim_m10 was float now byte
  variable exe_intensity_sim_m11 was float now byte
  variable exe_intensity_sim_m12 was float now byte
  variable exe_intensity_sim_m13 was float now byte
  variable exe_intensity_sim_m14 was float now byte
  variable exe_intensity_sim_m15 was float now byte
  variable exe_intensity_sim_m16 was float now byte
  variable exe_intensity_sim_m17 was float now byte
  variable exe_intensity_sim_m18 was float now byte
  variable exe_intensity_sim_m19 was float now byte
  variable exe_intensity_sim_m20 was float now byte
  variable exe_intensity_sim_f1 was float now byte
  variable exe_intensity_sim_f2 was float now byte
  variable exe_intensity_sim_f3 was float now byte
  variable exe_intensity_sim_f4 was float now byte
  variable exe_intensity_sim_f5 was float now byte
  variable exe_intensity_sim_f6 was float now byte
  variable exe_intensity_sim_f7 was float now byte
  variable exe_intensity_sim_f8 was float now byte
  variable exe_intensity_sim_f9 was float now byte
  variable exe_intensity_sim_f10 was float now byte
  variable exe_intensity_sim_f11 was float now byte
  variable exe_intensity_sim_f12 was float now byte
  variable exe_intensity_sim_f13 was float now byte
  variable exe_intensity_sim_f14 was float now byte
  variable exe_intensity_sim_f15 was float now byte
  variable exe_intensity_sim_f16 was float now byte
  variable exe_intensity_sim_f17 was float now byte
  variable exe_intensity_sim_f18 was float now byte
  variable exe_intensity_sim_f19 was float now byte
  variable exe_intensity_sim_f20 was float now byte
  variable exe_aerobic_advice_m1 was float now byte
  variable exe_aerobic_advice_m2 was float now byte
  variable exe_aerobic_advice_m3 was float now byte
  variable exe_aerobic_advice_m4 was float now byte
  variable exe_aerobic_advice_m5 was float now byte
  variable exe_aerobic_advice_m6 was float now byte
  variable exe_aerobic_advice_m7 was float now byte
  variable exe_aerobic_advice_m8 was float now byte
  variable exe_aerobic_advice_m9 was float now byte
  variable exe_aerobic_advice_m10 was float now byte
  variable exe_aerobic_advice_m11 was float now byte
  variable exe_aerobic_advice_m12 was float now byte
  variable exe_aerobic_advice_m13 was float now byte
  variable exe_aerobic_advice_m14 was float now byte
  variable exe_aerobic_advice_m15 was float now byte
  variable exe_aerobic_advice_m16 was float now byte
  variable exe_aerobic_advice_m17 was float now byte
  variable exe_aerobic_advice_m18 was float now byte
  variable exe_aerobic_advice_m19 was float now byte
  variable exe_aerobic_advice_m20 was float now byte
  variable exe_aerobic_advice_f1 was float now byte
  variable exe_aerobic_advice_f2 was float now byte
  variable exe_aerobic_advice_f3 was float now byte
  variable exe_aerobic_advice_f4 was float now byte
  variable exe_aerobic_advice_f5 was float now byte
  variable exe_aerobic_advice_f6 was float now byte
  variable exe_aerobic_advice_f7 was float now byte
  variable exe_aerobic_advice_f8 was float now byte
  variable exe_aerobic_advice_f9 was float now byte
  variable exe_aerobic_advice_f10 was float now byte
  variable exe_aerobic_advice_f11 was float now byte
  variable exe_aerobic_advice_f12 was float now byte
  variable exe_aerobic_advice_f13 was float now byte
  variable exe_aerobic_advice_f14 was float now byte
  variable exe_aerobic_advice_f15 was float now byte
  variable exe_aerobic_advice_f16 was float now byte
  variable exe_aerobic_advice_f17 was float now byte
  variable exe_aerobic_advice_f18 was float now byte
  variable exe_aerobic_advice_f19 was float now byte
  variable exe_aerobic_advice_f20 was float now byte
  variable exe_strength_advice_m1 was float now byte
  variable exe_strength_advice_m2 was float now byte
  variable exe_strength_advice_m3 was float now byte
  variable exe_strength_advice_m4 was float now byte
  variable exe_strength_advice_m5 was float now byte
  variable exe_strength_advice_m6 was float now byte
  variable exe_strength_advice_m7 was float now byte
  variable exe_strength_advice_m8 was float now byte
  variable exe_strength_advice_m9 was float now byte
  variable exe_strength_advice_m10 was float now byte
  variable exe_strength_advice_m11 was float now byte
  variable exe_strength_advice_m12 was float now byte
  variable exe_strength_advice_m13 was float now byte
  variable exe_strength_advice_m14 was float now byte
  variable exe_strength_advice_m15 was float now byte
  variable exe_strength_advice_m16 was float now byte
  variable exe_strength_advice_m17 was float now byte
  variable exe_strength_advice_m18 was float now byte
  variable exe_strength_advice_m19 was float now byte
  variable exe_strength_advice_m20 was float now byte
  variable exe_strength_advice_f1 was float now byte
  variable exe_strength_advice_f2 was float now byte
  variable exe_strength_advice_f3 was float now byte
  variable exe_strength_advice_f4 was float now byte
  variable exe_strength_advice_f5 was float now byte
  variable exe_strength_advice_f6 was float now byte
  variable exe_strength_advice_f7 was float now byte
  variable exe_strength_advice_f8 was float now byte
  variable exe_strength_advice_f9 was float now byte
  variable exe_strength_advice_f10 was float now byte
  variable exe_strength_advice_f11 was float now byte
  variable exe_strength_advice_f12 was float now byte
  variable exe_strength_advice_f13 was float now byte
  variable exe_strength_advice_f14 was float now byte
  variable exe_strength_advice_f15 was float now byte
  variable exe_strength_advice_f16 was float now byte
  variable exe_strength_advice_f17 was float now byte
  variable exe_strength_advice_f18 was float now byte
  variable exe_strength_advice_f19 was float now byte
  variable exe_strength_advice_f20 was float now byte
  variable exe_active_m1 was float now byte
  variable exe_active_m2 was float now byte
  variable exe_active_m3 was float now byte
  variable exe_active_m4 was float now byte
  variable exe_active_m5 was float now byte
  variable exe_active_m6 was float now byte
  variable exe_active_m7 was float now byte
  variable exe_active_m8 was float now byte
  variable exe_active_m9 was float now byte
  variable exe_active_m10 was float now byte
  variable exe_active_m11 was float now byte
  variable exe_active_m12 was float now byte
  variable exe_active_m13 was float now byte
  variable exe_active_m14 was float now byte
  variable exe_active_m15 was float now byte
  variable exe_active_m16 was float now byte
  variable exe_active_m17 was float now byte
  variable exe_active_m18 was float now byte
  variable exe_active_m19 was float now byte
  variable exe_active_m20 was float now byte
  variable exe_active_f1 was float now byte
  variable exe_active_f2 was float now byte
  variable exe_active_f3 was float now byte
  variable exe_active_f4 was float now byte
  variable exe_active_f5 was float now byte
  variable exe_active_f6 was float now byte
  variable exe_active_f7 was float now byte
  variable exe_active_f8 was float now byte
  variable exe_active_f9 was float now byte
  variable exe_active_f10 was float now byte
  variable exe_active_f11 was float now byte
  variable exe_active_f12 was float now byte
  variable exe_active_f13 was float now byte
  variable exe_active_f14 was float now byte
  variable exe_active_f15 was float now byte
  variable exe_active_f16 was float now byte
  variable exe_active_f17 was float now byte
  variable exe_active_f18 was float now byte
  variable exe_active_f19 was float now byte
  variable exe_active_f20 was float now byte
  variable exe_intensity_simplest_m1 was float now byte
  variable exe_intensity_simplest_m2 was float now byte
  variable exe_intensity_simplest_m3 was float now byte
  variable exe_intensity_simplest_m4 was float now byte
  variable exe_intensity_simplest_m5 was float now byte
  variable exe_intensity_simplest_m6 was float now byte
  variable exe_intensity_simplest_m7 was float now byte
  variable exe_intensity_simplest_m8 was float now byte
  variable exe_intensity_simplest_m9 was float now byte
  variable exe_intensity_simplest_m10 was float now byte
  variable exe_intensity_simplest_m11 was float now byte
  variable exe_intensity_simplest_m12 was float now byte
  variable exe_intensity_simplest_m13 was float now byte
  variable exe_intensity_simplest_m14 was float now byte
  variable exe_intensity_simplest_m15 was float now byte
  variable exe_intensity_simplest_m16 was float now byte
  variable exe_intensity_simplest_m17 was float now byte
  variable exe_intensity_simplest_m18 was float now byte
  variable exe_intensity_simplest_m19 was float now byte
  variable exe_intensity_simplest_m20 was float now byte
  variable exe_intensity_simplest_f1 was float now byte
  variable exe_intensity_simplest_f2 was float now byte
  variable exe_intensity_simplest_f3 was float now byte
  variable exe_intensity_simplest_f4 was float now byte
  variable exe_intensity_simplest_f5 was float now byte
  variable exe_intensity_simplest_f6 was float now byte
  variable exe_intensity_simplest_f7 was float now byte
  variable exe_intensity_simplest_f8 was float now byte
  variable exe_intensity_simplest_f9 was float now byte
  variable exe_intensity_simplest_f10 was float now byte
  variable exe_intensity_simplest_f11 was float now byte
  variable exe_intensity_simplest_f12 was float now byte
  variable exe_intensity_simplest_f13 was float now byte
  variable exe_intensity_simplest_f14 was float now byte
  variable exe_intensity_simplest_f15 was float now byte
  variable exe_intensity_simplest_f16 was float now byte
  variable exe_intensity_simplest_f17 was float now byte
  variable exe_intensity_simplest_f18 was float now byte
  variable exe_intensity_simplest_f19 was float now byte
  variable exe_intensity_simplest_f20 was float now byte
  variable exe_intensity_sim_m_cr0 was float now byte
  variable exe_intensity_sim_m_cr1 was float now byte
  variable exe_intensity_sim_m_cr2 was float now byte
  variable exe_intensity_sim_m_cr3 was float now byte
  variable exe_intensity_sim_m_cr4 was float now byte
  variable exe_intensity_sim_f_cr0 was float now byte
  variable exe_intensity_sim_f_cr1 was float now byte
  variable exe_intensity_sim_f_cr2 was float now byte
  variable exe_intensity_sim_f_cr3 was float now byte
  variable exe_intensity_sim_f_cr4 was float now byte
  variable exe_intensity_simplest_m_cr0 was float now byte
  variable exe_intensity_simplest_m_cr1 was float now byte
  variable exe_intensity_simplest_m_cr2 was float now byte
  variable exe_intensity_simplest_m_cr3 was float now byte
  variable exe_intensity_simplest_m_cr4 was float now byte
  variable exe_intensity_simplest_f_cr0 was float now byte
  variable exe_intensity_simplest_f_cr1 was float now byte
  variable exe_intensity_simplest_f_cr2 was float now byte
  variable exe_intensity_simplest_f_cr3 was float now byte
  variable exe_intensity_simplest_f_cr4 was float now byte
  variable exe_aerobic_advice_m_cr0 was float now byte
  variable exe_aerobic_advice_m_cr1 was float now byte
  variable exe_aerobic_advice_m_cr2 was float now byte
  variable exe_aerobic_advice_m_cr3 was float now byte
  variable exe_aerobic_advice_m_cr4 was float now byte
  variable exe_aerobic_advice_f_cr0 was float now byte
  variable exe_aerobic_advice_f_cr1 was float now byte
  variable exe_aerobic_advice_f_cr2 was float now byte
  variable exe_aerobic_advice_f_cr3 was float now byte
  variable exe_aerobic_advice_f_cr4 was float now byte
  variable exe_strength_advice_m_cr0 was float now byte
  variable exe_strength_advice_m_cr1 was float now byte
  variable exe_strength_advice_m_cr2 was float now byte
  variable exe_strength_advice_m_cr3 was float now byte
  variable exe_strength_advice_m_cr4 was float now byte
  variable exe_strength_advice_f_cr0 was float now byte
  variable exe_strength_advice_f_cr1 was float now byte
  variable exe_strength_advice_f_cr2 was float now byte
  variable exe_strength_advice_f_cr3 was float now byte
  variable exe_strength_advice_f_cr4 was float now byte
  variable exe_active_m_cr0 was float now byte
  variable exe_active_m_cr1 was float now byte
  variable exe_active_m_cr2 was float now byte
  variable exe_active_m_cr3 was float now byte
  variable exe_active_m_cr4 was float now byte
  variable exe_active_f_cr0 was float now byte
  variable exe_active_f_cr1 was float now byte
  variable exe_active_f_cr2 was float now byte
  variable exe_active_f_cr3 was float now byte
  variable exe_active_f_cr4 was float now byte
  variable _state was double now byte
  variable fmonth was double now byte
  variable dispcode was double now int
  variable _psu was double now long
  variable ctelenm1 was double now byte
  variable pvtresd1 was double now byte
  variable colghous was double now byte
  variable statere1 was double now byte
  variable celphone was double now byte
  variable ladult1 was double now byte
  variable colgsex was double now byte
  variable numadult was double now byte
  variable landsex was double now byte
  variable nummen was double now byte
  variable numwomen was double now byte
  variable respslct was double now byte
  variable safetime was double now byte
  variable ctelnum1 was double now byte
  variable cellfon5 was double now byte
  variable cadult1 was double now byte
  variable cellsex was double now byte
  variable pvtresd3 was double now byte
  variable cclghous was double now byte
  variable cstate1 was double now byte
  variable landline was double now byte
  variable hhadult was double now byte
  variable sexvar was double now byte
  variable genhlth was double now byte
  variable physhlth was double now byte
  variable menthlth was double now byte
  variable poorhlth was double now byte
  variable hlthpln1 was double now byte
  variable persdoc2 was double now byte
  variable medcost was double now byte
  variable checkup1 was double now byte
  variable bphigh4 was double now byte
  variable bpmeds was double now byte
  variable cholchk2 was double now byte
  variable toldhi2 was double now byte
  variable cholmed2 was double now byte
  variable cvdinfr4 was double now byte
  variable cvdcrhd4 was double now byte
  variable cvdstrk3 was double now byte
  variable asthma3 was double now byte
  variable asthnow was double now byte
  variable chcscncr was double now byte
  variable chcocncr was double now byte
  variable chccopd2 was double now byte
  variable addepev3 was double now byte
  variable chckdny2 was double now byte
  variable diabete4 was double now byte
  variable diabage3 was double now byte
  variable havarth4 was double now byte
  variable arthexer was double now byte
  variable arthedu was double now byte
  variable lmtjoin3 was double now byte
  variable arthdis2 was double now byte
  variable joinpai2 was double now byte
  variable marital was double now byte
  variable educa was double now byte
  variable renthom1 was double now byte
  variable numhhol3 was double now byte
  variable numphon3 was double now byte
  variable cpdemo1b was double now byte
  variable veteran3 was double now byte
  variable employ1 was double now byte
  variable children was double now byte
  variable income2 was double now byte
  variable weight2 was double now int
  variable height3 was double now int
  variable pregnant was double now byte
  variable deaf was double now byte
  variable blind was double now byte
  variable decide was double now byte
  variable diffwalk was double now byte
  variable diffdres was double now byte
  variable diffalon was double now byte
  variable smoke100 was double now byte
  variable smokday2 was double now byte
  variable stopsmk2 was double now byte
  variable lastsmk2 was double now byte
  variable usenow3 was double now byte
  variable alcday5 was double now int
  variable avedrnk3 was double now byte
  variable drnk3ge5 was double now byte
  variable maxdrnks was double now byte
  variable exerany2 was double now byte
  variable exract11 was double now byte
  variable exeroft1 was double now int
  variable exerhmm1 was double now int
  variable exract21 was double now byte
  variable exeroft2 was double now int
  variable exerhmm2 was double now int
  variable strength was double now int
  variable fruit2 was double now int
  variable fruitju2 was double now int
  variable fvgreen1 was double now int
  variable frenchf1 was double now int
  variable potatoe1 was double now int
  variable vegetab2 was double now int
  variable flushot7 was double now byte
  variable flshtmy3 was double now long
  variable tetanus1 was double now byte
  variable pneuvac4 was double now byte
  variable hivtst7 was double now byte
  variable hivtstd3 was double now long
  variable hivrisk5 was double now byte
  variable pdiabtst was double now byte
  variable prediab1 was double now byte
  variable insulin1 was double now byte
  variable bldsugar was double now int
  variable feetchk3 was double now int
  variable doctdiab was double now byte
  variable chkhemo3 was double now byte
  variable feetchk was double now byte
  variable eyeexam1 was double now byte
  variable diabeye was double now byte
  variable diabedu was double now byte
  variable toldcfs was double now byte
  variable havecfs was double now byte
  variable workcfs was double now byte
  variable toldhepc was double now byte
  variable trethepc was double now byte
  variable prirhepc was double now byte
  variable havehepc was double now byte
  variable havehepb was double now byte
  variable medshepb was double now byte
  variable hpvadvc3 was double now byte
  variable hpvadsht was double now byte
  variable imfvpla1 was double now byte
  variable shingle2 was double now byte
  variable lcsfirst was double now int
  variable lcslast was double now int
  variable lcsnumcg was double now int
  variable lcsctscn was double now byte
  variable hadmam was double now byte
  variable howlong was double now byte
  variable hadpap2 was double now byte
  variable lastpap2 was double now byte
  variable hpvtest was double now byte
  variable hplsttst was double now byte
  variable hadhyst2 was double now byte
  variable pcpsaad3 was double now byte
  variable pcpsadi1 was double now byte
  variable pcpsare1 was double now byte
  variable psatest1 was double now byte
  variable psatime was double now byte
  variable pcpsars1 was double now byte
  variable pcpsade1 was double now byte
  variable pcdmdec1 was double now byte
  variable bldstool was double now byte
  variable lstblds3 was double now byte
  variable hadsigm3 was double now byte
  variable hadsgco1 was double now byte
  variable lastsig3 was double now byte
  variable cncrdiff was double now byte
  variable cncrage was double now byte
  variable cncrtyp1 was double now byte
  variable csrvtrt3 was double now byte
  variable csrvdoc1 was double now byte
  variable csrvsum was double now byte
  variable csrvrtrn was double now byte
  variable csrvinst was double now byte
  variable csrvinsr was double now byte
  variable csrvdein was double now byte
  variable csrvclin was double now byte
  variable csrvpain was double now byte
  variable csrvctl2 was double now byte
  variable hlthcvr1 was double now byte
  variable aspirin was double now byte
  variable hombpchk was double now byte
  variable homrgchk was double now byte
  variable wherebp was double now byte
  variable sharebp was double now byte
  variable wtchsalt was double now byte
  variable dradvise was double now byte
  variable indortan was double now int
  variable numburn3 was double now int
  variable sunprtct was double now byte
  variable wkdayout was double now byte
  variable wkendout was double now byte
  variable cimemlos was double now byte
  variable cdhouse was double now byte
  variable cdassist was double now byte
  variable cdhelp was double now byte
  variable cdsocial was double now byte
  variable cddiscus was double now byte
  variable caregiv1 was double now byte
  variable crgvrel3 was double now byte
  variable crgvlng1 was double now byte
  variable crgvhrs1 was double now byte
  variable crgvprb3 was double now byte
  variable crgvalzd was double now byte
  variable crgvper1 was double now byte
  variable crgvhou1 was double now byte
  variable crgvexpt was double now byte
  variable acedeprs was double now byte
  variable acedrink was double now byte
  variable acedrugs was double now byte
  variable aceprisn was double now byte
  variable acedivrc was double now byte
  variable acepunch was double now byte
  variable acehurt1 was double now byte
  variable aceswear was double now byte
  variable acetouch was double now byte
  variable acetthem was double now byte
  variable acehvsex was double now byte
  variable pfpprvn3 was double now byte
  variable typcntr8 was double now byte
  variable nobcuse7 was double now byte
  variable asbialch was double now byte
  variable asbidrnk was double now byte
  variable asbibing was double now byte
  variable asbiadvc was double now byte
  variable asbirduc was double now byte
  variable marijan1 was double now byte
  variable usemrjn2 was double now byte
  variable rsnmrjn1 was double now byte
  variable foodstmp was double now byte
  variable birthsex was double now byte
  variable somale was double now byte
  variable sofemale was double now byte
  variable trnsgndr was double now byte
  variable rcsgendr was double now byte
  variable rcsrltn2 was double now byte
  variable casthdx2 was double now byte
  variable casthno2 was double now byte
  variable qstver was double now byte
  variable qstlang was double now byte
  variable _metstat was double now byte
  variable _urbstat was double now byte
  variable mscode was double now byte
  variable _ststr was double now long
  variable _imprace was double now byte
  variable _chispnc was double now byte
  variable _crace1 was double now byte
  variable _cprace was double now byte
  variable _dualuse was double now byte
  variable _rfhlth was double now byte
  variable _phys14d was double now byte
  variable _ment14d was double now byte
  variable _hcvu651 was double now byte
  variable _rfhype5 was double now byte
  variable _cholch2 was double now byte
  variable _rfchol2 was double now byte
  variable _michd was double now byte
  variable _ltasth1 was double now byte
  variable _casthm1 was double now byte
  variable _asthms1 was double now byte
  variable _drdxar2 was double now byte
  variable _lmtact2 was double now byte
  variable _lmtwrk2 was double now byte
  variable _prace1 was double now byte
  variable _mrace1 was double now byte
  variable _hispanc was double now byte
  variable _race was double now byte
  variable _raceg21 was double now byte
  variable _racegr3 was double now byte
  variable _race_g1 was double now byte
  variable _sex was double now byte
  variable _ageg5yr was double now byte
  variable _age65yr was double now byte
  variable _age80 was double now byte
  variable _age_g was double now byte
  variable htin4 was double now byte
  variable htm4 was double now int
  variable wtkg3 was double now int
  variable _bmi5 was double now int
  variable _bmi5cat was double now byte
  variable _rfbmi5 was double now byte
  variable _chldcnt was double now byte
  variable _educag was double now byte
  variable _incomg was double now byte
  variable _smoker3 was double now byte
  variable _rfsmok3 was double now byte
  variable drnkany5 was double now byte
  variable drocdy3_ was double now int
  variable _rfbing5 was double now byte
  variable _drnkwk1 was double now long
  variable _rfdrhv7 was double now byte
  variable _totinda was double now byte
  variable metvl11_ was double now int
  variable metvl21_ was double now int
  variable actin12_ was double now byte
  variable actin22_ was double now byte
  variable padur1_ was double now int
  variable padur2_ was double now int
  variable _minac11 was double now long
  variable _minac21 was double now long
  variable pamiss2_ was double now byte
  variable pamin12_ was double now long
  variable pamin22_ was double now long
  variable pa2min_ was double now long
  variable pavig12_ was double now int
  variable pavig22_ was double now long
  variable pa2vigm_ was double now long
  variable _pacat2 was double now byte
  variable _paindx2 was double now byte
  variable _pa150r3 was double now byte
  variable _pa300r3 was double now byte
  variable _pa30022 was double now byte
  variable _pastrng was double now byte
  variable _parec2 was double now byte
  variable _pastae2 was double now byte
  variable ftjuda2_ was double now int
  variable frutda2_ was double now int
  variable grenda1_ was double now int
  variable frnchda_ was double now int
  variable potada1_ was double now int
  variable vegeda2_ was double now int
  variable _misfrt1 was double now byte
  variable _misveg1 was double now byte
  variable _frtres1 was double now byte
  variable _vegres1 was double now byte
  variable _frutsu1 was double now int
  variable _vegesu1 was double now int
  variable _frtlt1a was double now byte
  variable _veglt1a was double now byte
  variable _frt16a was double now byte
  variable _veg23a was double now byte
  variable _fruite1 was double now byte
  variable _vegete1 was double now byte
  variable _flshot7 was double now byte
  variable _pneumo3 was double now byte
  variable _aidtst4 was double now byte
  variable psu was double now long
  (1,349,332,568 bytes saved)
r; t=366.90 5:13:08

. 
. 
. save "Data Ready for Analysis/brfss2019-readyforanalysis.dta",replace
file Data Ready for Analysis/brfss2019-readyforanalysis.dta saved
r; t=0.43 5:13:08

. 
. 
. 
. *Ouput data for multiple imputation
. drop if state==72 //delete Puerto Rico
(6,032 observations deleted)
r; t=0.05 5:13:08

. 
. keep id svyweight strata psu /// technical variables
> exercise exercise1type exercise1freq exercise1min exercise2type exercise2freq 
> exercise2min muscleexercise exe1_intensity exe2_intensity exe_intensity_simple
> st exe_aerobic_advice exe_strength_advice exe_active /// physical activities
> state yearsold male educ hhincome praceethnicgp_multi_sim ///
> srh badphyhlth badmenhlth bmicat employstatus_full //auxiliary variables
r; t=0.12 5:13:08

. 
. save "Data Ready for Analysis/brfss2019-readyforimpute.dta",replace
file Data Ready for Analysis/brfss2019-readyforimpute.dta saved
r; t=0.11 5:13:08

. 
. 
. 
. *Ouput data for listwise analysis
. use "Data Ready for Analysis/brfss2019-readyforanalysis.dta",clear
r; t=0.25 5:13:09

. 
. keep svyweight strata psu /// technical variables
> exe_aerobic_advice_m* exe_strength_advice_m* exe_aerobic_advice_f* exe_strengt
> h_advice_f* state yearsold year praceethnicgp_multi_sim male educ hhincome exe
> _aerobic_advice_m_cr* exe_strength_advice_m_cr* exe_aerobic_advice_f_cr* exe_s
> trength_advice_f_cr*
r; t=0.14 5:13:09

. save "Data Ready for Analysis/brfss2019-readyforlistwiseanalysis.dta",replace
file Data Ready for Analysis/brfss2019-readyforlistwiseanalysis.dta saved
r; t=0.15 5:13:09

. 
. 
. 
. *save `pgm'.dta,replace
. 
. *estwrite * using `pgm',replace
. 
. 
. log close
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20
> 250822-brfss2019-dataprep.log
  log type:  text
 closed on:  25 Aug 2025, 05:13:09
--------------------------------------------------------------------------------
